Reorganize tables
mantovamMar 23 2012 — edited Mar 26 2012Hi 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