Re: Consolidated Database Size in OEM

Be careful when querying MGMT$ views, many of them requieres license

https://docs.oracle.com/cd/E24628_01/doc.121/e24474/ch2_db_mgmt.htm#OEMLI119

https://docs.oracle.com/cd/E73210_01/OEMLI/GUID-B7FDEFFE-DECB-4826-A3C8-7660B013C5DE.htm#OEMLI115

On Sun, Dec 16, 2018 at 6:35 AM Ramnivas Chaurasia < ramnivaschaurasia_at_gmail.com> wrote:

> 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