Chapter 45
How I Reorganized a Large Database
Biju Thomas
Proper space management and less fragmentation is key to the performance of a database. Fragmentation happens over time. We call a tablespace fragmented when there is a lot of free space available, but they are in such small pieces that Oracle cannot use them. Whenever Oracle allocates next extent to an object, it looks for contiguous space. Coalescing the tablespace will only coalesce the free extents that are adjacent to each other. By querying the DBA_FREE_SPACE view, you can determine the extent of fragmentation in the tablespace. This chapter is a case study, encompassing the steps taken to reorganize a large application database. The idea here is to provide the steps and scripts ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
