Main

OEM Archives

August 31, 2008

Using OEM, want to know database growth pattern of last one month/year ?

Here are the steps to know Database growth pattern for last one month/year using OEM

1) Login to OEM and Click on the Reports Tab
2) Navigate to Reports-->Storage-->Oracle Database Space Usage path and Click on Oracle Database Space Usage link.
3) Select the Target database and here we are getting Oracle Database space usage for last one Month.
4) Also we can get one year Database growth by setting Set Time Period Button.
5) Also we can find Oracle Database Tablespace Monthly Space Usage by Navigating Reports-->Storage-->Oracle Database Space Usage path and click on Oracle Database Tablespace Monthly Space Usage link.

I hope this helps DBA's to plan for future disk space requirements.

December 21, 2008

Using OEM, want to see the list of tables to reclaim some space in a database and chained rows?

Steps to find Object Fragmentation and Chained Rows in a Database is:

1) Login to OEM and Click on Targets tab and Choose Database sub tab.
2) Click on required database and follow the path under Space summary >Segment findings.
3) Click Configure tab on right side. Provide Reclaimable space(%) ,Reclaimable Space(MB), Row Chaining (%) and Click on add button and select Tablespaces to be checked for row chaining.

For Row Chaining, the navigation path is
Reports->Storage->Oracle Database Space Issues->Segments with Row Chaining Issues

For Objects Fragmentation, the navigation path is
Reports->Storage->Oracle Database Space Issues->Tablespaces with Reclaimable Space

About OEM

This page contains an archive of all entries posted to Mukund Yadav's Blog on OEM and APPS R12 in the OEM category. They are listed from oldest to newest.

Apps R12 is the previous category.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type and Oracle