II. DBA Reference
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
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.
-
No Comment