DESCRIPTION
This custom report is really two report in one. It will provide either (choose the SQL script below as needed):
- A summary of space used for a given monitored instance.
To use this report, run it from SQL*Plus while connected to the Ignite repository database.
SQL*PLUS SCRIPT FOR ONE INSTANCE
column name format a50
select id, name from cond order by name
/
prompt Database ID:
accept DBID
column database_name format a50
select d.name database_name, sum(us.bytes)/1024/1024 mb
from cond d, user_segments us
where d.id = &DBID
and us.segment_name like 'CON%\_&DBID' escape '\'
group by d.name
/
SQL*Plus Script for Repository
select segment_name, segment_type, sum(bytes)/1024/1024 mb_used
from user_segments
group by segment_name, segment_type
order by 3 desc
/
