Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reorganize tables

mantovamMar 23 2012 — edited Mar 26 2012
Hi Folks

I doing a plan to improvements the performance database, and one of the tasks will be reorganize some tables.
To find the tables that need a "alter table move" and "index rebuild", I think that is good use the OEM Segment Advisor, to show the table that need the reorganize, and use this to create a script to the "alter table move" and "index rebuild".
The OEM Segment Advisor, will get the table that have free space to reclaim in database.

What you think about this ?
I know that maybe the performance does not will improvement, but will reclaim space.

And I think that the OEM Segment Advisor is a good way to do this.

Tks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2012
Added on Mar 23 2012
12 comments
1,213 views