Enterprise Manager Generic (MOSC)

MOSC Banner

Database Storage Report-Information Publisher Report

edited Aug 24, 2018 4:29PM in Enterprise Manager Generic (MOSC) 8 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center