Written by one the world's most widely-read Oracle instructors, Chris Foot leverages his substantial knowledge of Oracle OCP Certification training to create this unique instructors guide for teaching Oracle DBA certification candidates. This book is highly-technical and geared toward Oracle OCP DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Unlike other OCP Oracle certification study guides, this book is for the OCP instructor and covers those OCP topics that students find the most challenging. With comprehensive and highly-detailed examples, Foot concentrates on the key concepts that cause the most difficulty for the OCP certification candidate and presents the instructor with proven techniques for improving their ability to successfully pass the Oracle OCP exam.

* Provides the OCP instructor with targeted Oracle OCP testing content. * Helps ensure that OCP candidates pass the Oracle OCP certification exam on their first try. * Guides the OCP instructor through the important Oracle OCP test areas and key concepts. * Contains valuable Oracle OCP test-taking tips and techniques * Emphasizes those areas where the Oracle OCP exam candidate has the most trouble. * Focuses on the important OCP conceptual areas and OCP test content. * Provides practical and applied teaching techniques for Oracle OCP certification instructors.

About the Author:

Chris Foot   Christopher T. Foot is an Oracle certified senior-level instructor, a technical sales specialist and database architect for Contemporary Technology. With over 15 years experience with database technologies, Chris has taught hundreds of Oracle courses to thousands of students.  Chris is also a regular speaker at the International Oracle Users Group and Oracle Open World conferences.

Table of Contents:

 

Chapter 1 - Getting Started   Why Database Administration? Oracle Database Administration Responsibilities Oracle Classroom Education Oracle9i Curriculum Changes Oracle9i Oracle Certifications             Oracle Certified Database Associate (OCA)             Oracle Certified Database Professional (OCP)             Oracle Certified Master Database Administrator (OCM) Oracle9i DBA OCP Upgrade Path Other Recommend Classes Preparing for the Oracle Certified Professional Exams Taking the Certification Exams Finding Information Quickly – The Key to Success Reference Manuals Oracle Internal Resources External Resources Book Recommendations   Chapter 2 - Oracle Database Architectures   Oracle on Microsoft Windows Platforms Oracle on LINUX Platforms Oracle on Unix Platforms  Database Architecture Comparison Worksheet Venturing into the Great Unknown – New Database Architectures Chapter 3 - Oracle Database Design Review Meetings   Initial Overview of Proposed System Logical Data Model Review Designing for Performance Setting up a Successful Test System in Oracle Monitoring Performance During Testing Performance Design Reviews Preparation for Production Turnover             Post Production Turnover Oracle Database Design Review Meetings - Conclusion   Chapter 4 - Oracle Database Administration   Oracle Software Installation Migrating to new Oracle releases UNIX and LINUX Semaphores and Shared Memory Relinking Oracle8i and Oracle9i Products Windows Services Oracle Instance Administration Oracle9i Persistent Initialization Parameter Files Remote Startup/Shutdown Multiple Buffer Pools Specifying Default, Keep and Recycle Bufferpools in Oracle8 and Oracle8i Specifying Default, Keep and Recycle Bufferpools in Oracle9i Large Pool Java Pool Redo log Buffer Performance Buffer Performance is critical to Good Oracle Performance DBWR_IO_SLAVES vs DB_WRITER_PROCESSES     Chapter 5 – Oracle Database Objects   What Database Are You Working In? GLOGIN.SQL and LOGIN.SQL Choosing a Database Block Size Copying Databases Between Servers Oracle Tablespaces Temporary Tablespaces Create Tablespace Temporary vs. Create Temporary Tablespace Partitioning    Oracle 8 - Range Partitioning Index Partitioning Equi-Partitioned Objects Local Indexes Global Indexes Oracle8i – Hash and Range/Hash Composite Partitioning Oracle9i – List and Range/List Composite Partitioning Which Partitioning Technique Do I Choose? Oracle9i Tablespace Changes Locally Managed System Tablespaces Rollback Segments When is the System Rollback Segment Used? Why is Oracle Recommending Minextents of 20 for Rollback Segments? Rollback Segments and Transaction Processing Workloads Batch and On-line Processing Rollback Segments and Users – Who’s Using What? Oracle9i - Database Managed Undo Segments Redo Logs Checkpoint Not Complete Resizing Redo Logs Oracle Tables and Indexes Space Utilization for Parallel Table Creates Index-only Tables Single Table Hash Clusters Oracle9i External Tables ALTER TABLE MOVE Statement ALTER COLUMN RENAME Statement On-line Table Reorganizations PCTFREE and PCTUSED Caching Tables Clustering Data in Tables Merging Tables to Increase Query Performance How Many Indexes Can I Build? Parameters that Impact Index Usage Index-Only Access Index Rebuilds Index Coalesce vs Index Rebuild Function-Based Indexes Bitmap Indexes Concurrency and Bitmap Indexes When to Use Bitmap Indexes Optimizer and Bitmap Indexes Bitmap vs B-Tree Indexing Hints Tips and Tricks Index Monitoring

Chapter 6 - Oracle Backup and Recovery   It’s the Little Things That Bite You Keep Your Skills Sharp RELAX and Plan Your Attack Don’t Be Afraid to Ask Others Instance Recovery and the Oracle Synchronization Process Uncommitted Data on the Data Files Committed Data Not On the Data Files The Synchronization Process Roll Forward Phase Roll Backward Phase Exports and Recovery V$RECOVERFILE Watch the NOLOGGING Option Striped File Systems Data Files and Redo Logs Redo Log and Control File Multiplexing OCOPY for NT Hot Backup Scripts for NT Hot Backup Scripts for UNIX Oracle9i – Lazy Checkpointer Recovery Manager Recovery Catalog Recovery Manager Backup Types Parallel Backup and Recovery Multiplexed Backup Sets Backup/Recovery Reports Database Recovery RMAN Examples DB_VERIFY       Chapter 7 – Tuning and Performance   Be careful with the ANALYZE command Finding Problem Queries Optimizer Plan Stability Pinning Objects in the Shared Pool PCTFREE and PCTUSED Caching Tables Clustering Data in Tables Merging Tables to Increase Query Performance Hints Parallel Hints Performance Testing Parallel Query Tuning Oracle on Windows Tuning Pack Direct Load Inserts Parallel DML Processing Materialized Views Database Resource Management STATSPACK V$ TABLES vs Oracle BSTAT/ESTAT and STATSPACK Segment-Level Performance Statistics Collection Performance Tuning Intelligent Advisories Optimizer Dynamic Sampling Data Segment Compression Using Explain Pan to Determine Access Paths Explain Plan Output SQL*PLUS AUTOTRACE High Water Mark and Table Scans     Chapter 8  – Miscellaneous Oracle Information   The Foot Rule of Thumb Monitor By Day So You Don’t Get Called at Night Monitoring Space Utilization and Performance Statistics Historically Latches and Enqueues Deadlock Detection Unindexed Foreign Keys and Locking Problems Using PUPBLD Copying databases between servers Oracle9i - Resumable Space Allocation Oracle9i – Flashback Query Full Database Exports Large Table Imports Compressing Export Output Files in UNIX Terminating Oracle Processes (Threads) in Windows Systems Truncating vs Deleting Copy Command in SQL*PLUS Displaying Time in Milliseconds !, $ and Host Command Differences Learn Command Line BEFORE Using "Sissy GUI Tools"  Don’t Write Scripts Don’t’ Write Iterative SQL Statements – Generate SQL with SQL Input Truncated to 9 Characters     Chapter 9  – Evaluating Third Party Products   Initial Analysis Determine Impact to the Information Technology Support Infrastructure Analysis Evaluation Obtain Business Unit and IT Management Commitment Create Evaluation Team Locate Potential Vendors Initial Elimination Vendor Evaluation Communicate Results     Chapter 10  – Ease of Administration   Good Documentation is Essential Follow OFA Naming Conventions Proceduralize Administrative Support for the Application Development Process Proceduralize the Change Request Process Oracle Authorization Request Form Oracle Database Change Request Form Oracle Migration to Production Request Form Create and Standardize Monitoring and Administration Scripts Repeatable Processes Create Service Level Agreements DBA Report Cards and the 360-Degree Review Process Corrective Action Reports     Chapter 11 – Database Security   Protecting Data Requires More than just Protecting the Production Database Identifying Granted Privileges Accounts Created During Database Creation Wrapping PL/SQL Programs Using OPS$ Accounts Using Security Profiles SYS and SYSTEM Passwords GRANT ANY OBJECT Privilege Administrative User Auditing Moving the AUD$ Tabl