Oracle DBA Interview Questions Part 1 »
| 0 Comments |
If a table space shows excessive fragmentation what are some methods to defragment the table space? (7.1,7.2 and 7.3 only)
In Oracle 7.0 to 7.2 The use of the ‘alter session set events ‘immediate trace name coalesce level ts# command is the easiest way to defragment contiguous free space fragmentation. The ts# parameter corresponds to the [...]
