Note: Technical Talk being moved to:

Thursday, 20 November 2008

Oracle OEM Mining

It can be quite useful to mine the tables stored in the Oracle Enterprise Manager repository.

To check the size of your databases in gigabytes, simply run:

select target_name
     , to_char (sum (file_size) / 1024 / 1024 / 1024, '999,999.99') sze
  from mgmt$db_datafiles_all
group by target_name
order by 2 desc;

No comments: