Chapter 50
Managing Oracle Table Freelists
Donald K. Burleson
One of the benefits of having a sophisticated database management system (DBMS) is that we are not concerned about the internals of how database objects are managed. However, the experienced Oracle professional must understand how Oracle manages table extents and free data blocks.
To become successful in managing high-volume simultaneous update activity, the Oracle database administrator (DBA) must intimately understand Oracle’s table management strategy. This includes the behavior of freelists, freelist groups, and their relationship to PCTFREE and PCTUSED.
Oracle professionals must understand freelist management because there are many occasions when poor table performance directly ...
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.
