Hello Everyone, I have few question about table defragmentation. We are planning to do de fragmentation of the table, 1. Do we have t take tablespace off line for that? 2. Are the tables available for select during defragmentation? 3. Are the tables available for inserts during defragmentation period? 4. How is this going to help database?
I have few question about table defragmentation. We are planning to do de fragmentation of the table, You have decided to do something called "table defragmentation". Now why ask then? First explain fragmentation and defragmentation.
4. How is this going to help database? It's probably not going to help and most likely will be a wasted effort. Why do you want to defragment your table? What do you hope to gain? Note....I never defragment my tables or indexes as I do not see any benefit from that effort. HTH, Brian
if u r using oracle version10g and above you can use the move table command.
DK2010 wrote: if u r using oracle version10g and above you can use the move table command. How to decide which table(s) to move? Is the result like rearranging the deck chairs on the Titanic?
It could hurt in a couple of circumstances: If you do an import/export, a table that is dense may get less dense whilst honoring pctfree or large initial values. This could slow down full table scans, if you have such things. If there is some implicit data distribution that helps your performance, this could go away. It may help to tell us what version/patch level you are on, where you got the idea you should defragment, and what exactly you were told. Do you have a performance issue?