Negative Values For Tablespace

11g OEM Grid Control

OEM 11g Bug

bug 9548105

• OEM 11g doesn't list datafiles when tablespace is 100% full
• Negative Values Reported By Dbconsole For Tablespace With At Least Two Datafiles

Fix

Apply Patch 9548105

Test Case

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,
(SELECT ts.name tablespace_name, SUM (e.LENGTH * ts.blocksize) bytes
FROM sys.fet$ e, sys.ts$ ts
WHERE ts.ts# = e.ts#
GROUP BY ts.name
UNION ALL
SELECT ts.name tablespace_name, SUM (e.blocks * ts.blocksize) bytes
FROM sys.dba_lmt_free_space e, sys.ts$ ts
WHERE ts.ts# = e.tablespace_id
GROUP BY ts.name) s
WHERE (s.tablespace_name = d.tablespace_name) AND (d.tablespace_name = '&tbs');

Hope this help. Regards Rupam