Database Storage Report-Information Publisher Report
Dear All,
We need to generate Database Storage Report like Total Database Available, Used and Free on Daily basis via OEM- as we know oracle provides some default views for Reports but we cant find any Report for Database storage
select round(sum(used.bytes)/1024/1024/1024) || 'GB' "Database Size",
round(sum(used.bytes)/1024/1024/1024)-
round(free.p/1024/1024/1024) || 'GB' "Used space",
round(free.p/1024/1024/1024) || 'GB' "Free space"
from(select bytes from v$datafile
union all
select bytes from v$tempfile
union all
select bytes from v$log) used
,(select sum(bytes) as p
from dba_free_space) free
group by free.p
/
But Via OEM Repository looks like we have use this by two ways like creating Metric extension and using that Metric Extension in custom Created Information Publisher Reports-I tried to do this but the Table show blank and it is unable to retrieve nothing