« Using OEM, want to know database growth pattern of last one month/year ? | Main | Apps R12 Self Study quick guide »

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

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mt/mt-tb.cgi/9055

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on December 21, 2008 12:40 AM.

The previous post in this blog was Using OEM, want to know database growth pattern of last one month/year ?.

The next post in this blog is Apps R12 Self Study quick guide.

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

Powered by
Movable Type and Oracle