13.7. Exam Essentials

Be able to monitor space usage in a tablespace. Respond to space warning and critical alerts by adding disk space or removing objects. Adjust the space thresholds using either DBMS_SERVER_ALERT or the EM Database Control interface.

Describe two types of segments that can provide benefits beyond the traditional heap-based table segments. Use index-organized tables to maximize performance and space usage for tables exclusively accessed by the primary key. Leverage clustered tables to maximize performance for tables that are frequently joined in a query.

List the tools and methods available to monitor and maintain indexes. Be able to list the pros and cons of rebuilding an index versus coalescing an index. Identify the dynamic ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 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.