Part II. DBA Reference

This part of the book provides detailed reference information you will need to perform Oracle database administration, including extensive statement syntax and parameter settings.

  • Chapter 10, describes the elements of the Oracle instance—in particular, the various Oracle processes and memory structures.

  • Chapter 11, describes the elements of the database (physical files and tablespaces) and storage allocation.

  • Chapter 12, provides a quick reference to the Oracle initialization parameters stored in the INIT.ORA file.

  • Chapter 13, provides a quick reference to the SQL statements used by the DBA.

  • Chapter 14, provides a quick reference to the data dictionary views used by the DBA.

  • Chapter 15, provides a quick reference to the system privileges implemented by Oracle and to the initial, or default, roles created by Oracle.

  • Chapter 16, provides a quick reference to the commands and parameters used with the tools most often used by the DBA: SQL*Plus, Export, Import, and SQL*Loader.

  • Appendix A, summarizes the books, magazines, organizations, web sites, discussion groups, and list servers that DBAs should find helpful sources of additional information.

Get Oracle Database Administration: The Essential Refe 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.