X
ORACLE TABLE MANAGEMENT
The management of objects within the Oracle database can have a huge impact on the performance of the Oracle system. Oracle maintains its own internal control structures within every Oracle object, including tables and indexes, and requires proper settings for all of the storage parameters, especially percent free, percent used, and free list parameter.
Prior to the development of employees object reorganizations in Oracle I, it was the challenge of the Oracle administrator to identify those tables and indexes which were functioning in some optimal levels and schedule those for reorganization. Object reorganizations are primarily used to clean up to and coalesce the Oracle free list, remove chained rows, and place ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access