Getting the size of all databases in a grid?
1006504May 1 2013 — edited May 1 2013Hi,
We currently using Oracle Enterprise Manager 10g to look after a large number of databases. I have been asked to gather information about them all including their current size.
Is anyone able to advise me of the best way to do this? I tried goggling and searching the forum but have not managed to find anything yet.
I have tried creating a 'Oracle Database Space Usage' report within enterprise manager to give me the database size. I can get the allocated, used and allocated free space for a single database but not all of them in one report. I have also been told that I should be able to get this information from the sysman schema. I have found some sites describing how to get other info from here but not the database size.
I know this is probably a fairly basic question but I am still very new to enterprise manager. Any advice or pointers to relevant docs that I can read would be greatly appreciated.
Thanks,
Andrew.