Search This Blog

Showing posts with label Using OEM. Show all posts
Showing posts with label Using OEM. Show all posts

Sunday, April 15, 2012

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.

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