InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If A Tablespace Shows Excessive Fragmentation What Are Some Methods To Defragment The Tablespace? (7.1,7.2 And 7.3 Only) |
|
Answer» 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 ts# value found in the ts$ SYS table. In version 7.3 the ‘alter tablespace coalesce;’ is best. If free space isn’t contiguous then export, drop and import of the tablespace contents MAY be the only way to RECLAIM non-contiguous free space. 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 ts# value found in the ts$ SYS table. In version 7.3 the ‘alter tablespace coalesce;’ is best. If free space isn’t contiguous then export, drop and import of the tablespace contents may be the only way to reclaim non-contiguous free space. |
|