Re: Consolidated Database Size in OEM
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 15 Dec 2018 23:37:11 -0500
Message-ID: <18f32140-1a57-01b1-98e7-2352d58eec05_at_gmail.com>
Date: Sat, 15 Dec 2018 23:37:11 -0500
Message-ID: <18f32140-1a57-01b1-98e7-2352d58eec05_at_gmail.com>
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-lReceived on Sun Dec 16 2018 - 05:37:11 CET