Oracle Database Administration
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
Oracle Database Administration
If one hundred Oracle database administrators were asked to define what a DBA does, the exercise would probably result in one hundred different descriptions. Nonetheless, there would be a high degree of commonality among these descriptions, and taken as a whole they would probably yield a fairly accurate job description for an Oracle DBA.
When Educational Testing Service (ETS) set out to develop a certification examination for Oracle DBAs a few years ago, the company’s first step was to perform a job analysis, which is a formal way of evaluating and describing a job. The process ETS followed included these steps:
A group of experts was asked to assemble a laundry list of the tasks, skills, and abilities required of a DBA. A survey instrument was developed that listed these items along with a rating scale for the importance of each item.
The survey was administered to a large number of Oracle DBAs around the world.
The survey results were tabulated, yielding an average importance rating for each task, skill, and ability. Those falling below a predetermined cutoff level were eliminated.
The result was a detailed description of the tasks performed by a DBA, and of the specific knowledge and abilities required to perform those tasks. This DBA job analysis then became the blueprint for the Certified Oracle Database Administrator examination.
-
No Comment