 |
|
OCP Instructors Guide for Oracle DBA
Certification
A Study Guide to Advanced Oracle Certified Professional
Database Administration Techniques
Christopher Foot
ISBN: 0-9740716-1-7
329 Pages
Retail Price $24.95
/ £17.95
- Order direct get 50% off
the retail price!
Only $14.95

|
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
|
|
|
|