{"id":2265,"date":"2011-09-19T05:41:00","date_gmt":"2011-09-19T03:41:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/"},"modified":"2011-09-19T05:41:00","modified_gmt":"2011-09-19T03:41:00","slug":"database-space-management-issue-with-grid-control-11g","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/","title":{"rendered":"Database space management issue with Grid Control 11g"},"content":{"rendered":"

My colleague Herv\u00e9 Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database \u2013 in our case a 10.2.0.3 target database. This post continues my last post about the free space management in a tablespace in relation to the recycle bin management.<\/p>\n

While using Grid Control 11g (with PSU 3 \u2013 April 2011) we would like to check the free space in the tablespaces. Let\u2019s focus on the tablespace CADP_DATA:<\/p>\n

\"spacegrid1\"<\/p>\n

This tablespace has 89.7 % of the space allocated (extents used by any object). Just to make the things clear, no recycle bin objects (dropped objects, see my previous post) do allocate any space in a tablespace:<\/p>\n

\n
SQL> select * from dba_recyclebin;\nno rows selected<\/pre>\n<\/div>\n
Now, let\u2019s drill down to the datafile level of the tablespace – just click on the \u201cCADP_DATA\u201d link.<\/p>\n
Obviously, something appears to be very strange: it seems that only between 1865 MB and 2865 MB of space is used in each datafile (each datafile is between 6 GB and 7 GB big):<\/p>\n
\"spacegrid2\"<\/p>\n
While performing the sum of the real used space we have about 15190 MB (15,19 GB) from a total of 40 GB of available datafiles. This is far away from the 89.7 % of reported allocated space.<\/p>\n
We focus on the \u201cdatafile\u201d view (click on \u2192 Server \u2192 Storage \/ Datafiles):<\/p>\n
\"spacegrid3\"<\/p>\n
Here is what we see:<\/p>\n
\"spacegrid4\"<\/p>\n
All the datafiles of the CADP_DATA tablespace have between 90% and 100% of used space. The last one has 2600 MB of remaining free space. This view is again coherent with the \u201ctablespace\u201d view (89.7% of the space is allocated).<\/p>\n
So let\u2019s try to identify why the datafile drill down view is somehow \u201cbuggy\u201d. Honestly, my first thinking was that the package \u201cdbms_space.free_space()\u201d procedure was used in the calculation in order to provide the real used space (not the allocated one) for each datafile. However, with a database featuring thousands of objects, such a procedure would never come to an end!<\/p>\n
So what can be the reason of this mystery? Hopefully this datafile space information is not reported by the agent but directly retrieved by the user you used to connect with on the target database. Therefore it becomes easy to identify the session and the SQL statement through the views v$session and v$sql. That\u2019s exactly what I did once I clicked on the tablespace name to drill down to the datafile view (the statement was cached in v$sql):<\/p>\n
SQL> r\n 1\u00a0 select sid,serial#,program,username,status,sq.sql_text\n 2\u00a0 from v$session ses, v$sql sq\n 3\u00a0 where username = 'SYS'\n 4\u00a0 and program = 'OMS'\n 5* and sq.address = ses.sql_address\nSID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SERIAL#\u00a0\u00a0\u00a0 PROGRAM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STATUS\n---------- ---------- ------------------------------------------------ ---------------------------- -------\nSQL_TEXT\n-------------------------------------------------------------------------------------------------------------\n 251\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18403\u00a0\u00a0\u00a0\u00a0\u00a0 OMS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INACTIVE<\/pre>\n
SELECT d.file_name, TO_CHAR((d.bytes \/ 1024 \/ 1024), ‘99999990.000’), NVL(TO_CHAR(((d.bytes – s.bytes) \/ 1024 \/ 1024), ‘99999990.000’), TO_CHAR((d.bytes \/ 1024 \/ 1024), ‘99999990.000’)), d.file_id, d.autoextensible, d.increment_by, d.maxblocks FROM sys.dba_data_files d,\u00a0 (SELECT ts.name tablespace_name, SUM(e.length * ts.blocksize) bytes\u00a0 FROM sys.fet$ e, sys.ts$ ts\u00a0 WHERE ts.ts# = e.ts# GROUP BY ts.name\u00a0 UNION ALL\u00a0 SELECT ts.name tablespace_name, SUM(e.blocks * ts.blocksize) bytes\u00a0 FROM sys.dba_lmt_free_space e, sys.ts$ ts\u00a0 WHERE ts.ts# = e.tablespace_id GROUP BY ts.name) s WHERE (s.tablespace_name = d.tablespace_name) AND (d.tablespace_name = :1)<\/i><\/span>
\nIt then became very easy to start this statement with the following condition \u201cd.tablespace_name = \u2018CADP_DATA\u2019\u201d in order to get the following result:<\/p>\n
SQL> r\n 1\u00a0 SELECT d.file_name,\n 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((d.bytes \/ 1024 \/ 1024), '99999990.000'),\n 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NVL(TO_CHAR(((d.bytes - s.bytes) \/ 1024 \/ 1024), '99999990.000'),\n 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((d.bytes \/ 1024 \/ 1024), '99999990.000')),\n 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.file_id,\n 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.autoextensible,\n 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.increment_by,\n 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.maxblocks\n 9\u00a0 FROM sys.dba_data_files d,(SELECT ts.name tablespace_name, SUM(e.length * ts.blocksize) bytes\n 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM sys.fet$ e, sys.ts$ ts\u00a0 WHERE ts.ts# = e.ts# GROUP BY ts.name\n 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNION ALL SELECT ts.name tablespace_name, SUM(e.blocks * ts.blocksize) bytes\n 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM sys.dba_lmt_free_space e, sys.ts$ ts\u00a0 WHERE ts.ts# = e.tablespace_id GROUP BY ts.name) s\n 13* WHERE (s.tablespace_name = d.tablespace_name) AND (d.tablespace_name = 'CADP_DATA')\nFILE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((D.BY NVL(TO_CHAR((\u00a0\u00a0\u00a0 FILE_ID AUT INCREMENT_BY\u00a0 MAXBLOCKS\n-------------------------------------------------- ------------- ------------- ---------- --- ------------ ----------\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_4.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 2863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_3.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 2863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_2.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 2863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_1.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 2863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_6.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6000.000\u00a0\u00a0\u00a0\u00a0\u00a0 1863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_5.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6000.000\u00a0\u00a0\u00a0\u00a0\u00a0 1863.375\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n6 rows selected.<\/pre>\n
Hopefully, we get exactly the same result as the buggy view in Grid Control:<\/p>\n
Let\u2019s have a deeper look at the SQL statement itself. The sub-select identified with the \u201cs\u201d alias (in bold) accesses on the fet$ table (for dictionary managed tablespaces) and dba_lmt_free_space view (for locally managed tablespaces). However it is strange to decrement the free space of the TABLESPACE from the size of the DATAFILE! And that\u2019s exactly what this query is doing: there is a mix up between the datafile sizes and the tablespace sizes \u2013 therefore this error.<\/p>\n
With some minor engineering we can fix this select statement to get the correct information. Do not forget the outer join for the FILE_ID, in order to also retrieve the files without free space:<\/p>\n
SQL> r\n 1\u00a0 SELECT d.file_name,\n 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((d.bytes \/ 1024 \/ 1024), '99999990.000'),\n 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NVL(TO_CHAR(((d.bytes - s.bytes) \/ 1024 \/ 1024), '99999990.000'),\n 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((d.bytes \/ 1024 \/ 1024), '99999990.000')),\n 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.file_id,\n 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.autoextensible,\n 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.increment_by,\n 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d.maxblocks\n 9\u00a0 FROM sys.dba_data_files d, ( SELECT e.file# s_file_id, sum(e.length * ts.blocksize) bytes\n 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM sys.fet$ e, sys.ts$ ts\n 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE ts.ts# = e.ts#\n 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GROUP BY e.file#\n 13\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNION ALL SELECT e.file_id s_file_id, sum(e.blocks * ts.blocksize) bytes\n 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM sys.dba_lmt_free_space e, sys.ts$ ts\n 15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE ts.ts# = e.tablespace_id\n 16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GROUP BY e.file_id) s\n 17\u00a0 WHERE (s.s_file_id (+) = d.file_id) AND (d.tablespace_name = 'CADP_DATA')\n 18* order by 1\nFILE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TO_CHAR((D.BY NVL(TO_CHAR((\u00a0\u00a0\u00a0 FILE_ID AUT INCREMENT_BY\u00a0 MAXBLOCKS\n-------------------------------------------------- ------------- ------------- ---------- --- ------------ ----------\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_1.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_2.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_3.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 6596.188\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_4.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7000.000\u00a0\u00a0\u00a0\u00a0\u00a0 6386.063\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_5.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6000.000\u00a0\u00a0\u00a0\u00a0\u00a0 5484.063\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\/sg_PCADP\/u01\/oradata\/R2CADP\/CADP_DATA_6.DBF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6000.000\u00a0\u00a0\u00a0\u00a0\u00a0 3401.063\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/pre>\n","protected":false},"excerpt":{"rendered":"
My colleague Herv\u00e9 Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database \u2013 in our case a 10.2.0.3 target database. This post continues my last post about the free space management in a tablespace in relation to the recycle bin management.<\/p>\n","protected":false},"author":9,"featured_media":2266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[258,33,17,24],"type_dbi":[],"class_list":["post-2265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-grid","tag-oracle-10g-to-8i","tag-oracle-11g","tag-pl-sql"],"acf":[],"yoast_head":"\nDatabase space management issue with Grid Control 11g - dbi Blog<\/title>\n<meta name=\"description\" content=\"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database space management issue with Grid Control 11g\" \/>\n<meta property=\"og:description\" content=\"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-19T03:41:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"606\" \/>\n\t<meta property=\"og:image:height\" content=\"195\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yann Neuhaus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yann Neuhaus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/\"},\"author\":{\"name\":\"Yann Neuhaus\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5bfc203607127a4915b7950c4a108681\"},\"headline\":\"Database space management issue with Grid Control 11g\",\"datePublished\":\"2011-09-19T03:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/\"},\"wordCount\":672,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/spacegrid1.jpg\",\"keywords\":[\"Grid\",\"Oracle 10g to 8i\",\"Oracle 11g\",\"PL\\\/SQL\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/\",\"name\":\"Database space management issue with Grid Control 11g - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/spacegrid1.jpg\",\"datePublished\":\"2011-09-19T03:41:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5bfc203607127a4915b7950c4a108681\"},\"description\":\"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/spacegrid1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/spacegrid1.jpg\",\"width\":606,\"height\":195},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/database-space-management-issue-with-grid-control-11g\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database space management issue with Grid Control 11g\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5bfc203607127a4915b7950c4a108681\",\"name\":\"Yann Neuhaus\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"caption\":\"Yann Neuhaus\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/yann-neuhaus\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database space management issue with Grid Control 11g - dbi Blog","description":"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/","og_locale":"en_US","og_type":"article","og_title":"Database space management issue with Grid Control 11g","og_description":"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).","og_url":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/","og_site_name":"dbi Blog","article_published_time":"2011-09-19T03:41:00+00:00","og_image":[{"width":606,"height":195,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg","type":"image\/jpeg"}],"author":"Yann Neuhaus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yann Neuhaus","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/"},"author":{"name":"Yann Neuhaus","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"headline":"Database space management issue with Grid Control 11g","datePublished":"2011-09-19T03:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/"},"wordCount":672,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg","keywords":["Grid","Oracle 10g to 8i","Oracle 11g","PL\/SQL"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/","url":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/","name":"Database space management issue with Grid Control 11g - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg","datePublished":"2011-09-19T03:41:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"description":"Using Grid Control 11g while monitoring the available space on an Oracle database (10.2.0.3 target database).","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/spacegrid1.jpg","width":606,"height":195},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/database-space-management-issue-with-grid-control-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Database space management issue with Grid Control 11g"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681","name":"Yann Neuhaus","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","caption":"Yann Neuhaus"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2265"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2266"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2265"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}