Re: Consolidated Database Size in OEM

Query below might be helpful. It works on OEM 13c:

select target_name, column_label,average, maximum from sysman.MGMT$METRIC_DAILY
where target_type='oracle_database'
and column_label in ('Allocated Space(GB)','Used Space(GB)' and rollup_timestamp >= trunc(sysdate);

You may adjust the "rollup_timestamp" condition based on the frequency agents load the data.

Regards,
Ramniwas

On Sun, Dec 16, 2018 at 10:08 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> What do you need repository for? Usually, it's done from the database
> itself:
>
> SQL> set sqlformat ansiconsole
> SQL> select con_id,sum(bytes)/1048575 MB
> 2 from cdb_data_files
> 3 group by rollup(con_id);
> CON_ID MB
> 1 1970.001878740195026583696922013208401879
> 4 905.000863076079441146317621533986600863
> 2875.002741816274467730014543547195002742
>
> There may be some problems with executing this on a 11G database. However,
> in approximately 2 weeks, Oracle 11G will die. Extended support will no
> longer be available for free. If there is something strange in your
> database, who you gonna call? Definitely not Oracle.
>
> Regards
> On 12/15/18 7:23 PM, Nagaraj chk wrote:
>
> Hi Gurus ,
>
> I am looking for a query to get the database size from OEM Repository
> database. Please help if anyone of you have query in handy.
>
> -Naga
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l