Chapter 13. Monitoring and Managing Storage

ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Monitoring and Managing Storage

    • Tune redo writing and archiving operations.

    • Issue statements that can be suspended upon encountering space condition errors.

    • Reduce space-related error conditions by proactively managing tablespace usage.

    • Reclaim wasted space from tables and indexes using the segment shrink functionality.

    • Estimate the size of new tables and indexes.

    • Use different storage options to improve the performance of queries.

    • Rebuild indexes online.

NOTE

Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/ ...

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.