Re: Consolidated Database Size in OEM
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
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:
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
> 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
Received on Sun Dec 16 2018 - 05:37:11 CET