Rampant TechPress

OCP Instructors Guide for Oracle DBA Certification Ebook

$12.50

OCP Instructors Guide for Oracle DBA Certification Ebook

Click to enlarge

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

Key Features

About the Author

Table of Contents

- 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

For more information, please visit this products webpage.

This product was added to our catalog on Saturday 30 August, 2003.

Customers who bought this product also purchased

Oracle Grid & Real Application Clusters	Easy Oracle SQL	Easy Oracle PLSQL
Oracle Forensics	Oracle 11g New Features	Oracle Shell Scripting