OCP Instructors Guide for Oracle DBA Certification : A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques

by Unknown

• ISBN13: 9780974435534
• ISBN10: 0974435538
• Format: Trade Paper
• Copyright: 2004-04-01
• Publisher: Rampant Techpress

Summary

Written by one of the world's top Oracle instructors, Chris Foot leverages his substantial knowledge of Oracle OCP Certification training to create this unique instructor's 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. Book jacket.

Author Biography

Christopher T. Foot is an Oracle certified instructor, technical sales specialist, and database architect for Contemporary Technology. He is a regular speaker at the International Oracle Users Group and Oracle Open World conferences. He lives in Silver Springs, Maryland.

Table of Contents

Using the Online Code Depot	1	(1)
Conventions Used in this Book	2	(2)
Acknowledgements	4	(1)
Foreword	5	(2)
Chapter 1 - Getting Started	7	(28)
Why Become an Oracle Database Administrator?	7	(2)
Oracle Database Administration Responsibilities	9	(6)
Oracle Classroom Education	15	(1)
Oracle9i Curriculum Changes	16	(2)
Oracle9i Oracle Certifications	18	(3)
Oracle Certified Database Associate (OCA)	18	(2)
Oracle Certified Database Professional (OCP)	20	(1)
Oracle Certified Master Database Administrator (OCM)	21	(1)
Oracle9i DBA OCP Upgrade Path	21	(2)
Other Recommend Classes	23	(2)
Preparing for the Oracle Certified Professional Exams	25	(1)
Taking the Certification Exams	26	(1)
Finding Information Quickly - The Key to Success	27	(6)
Reference Manuals	28	(1)
Oracle Internal Resources	29	(1)
External Resources	30	(1)
Book Recommendations	31	(2)
Conclusion	33	(2)
Chapter 2 - Oracle Database Architectures	35	(12)
Oracle Database Architectures	35	(1)
Oracle on Microsoft Windows Platforms	36	(2)
Oracle on LINUX Platforms	38	(3)
Oracle on Unix Platforms	41	(2)
Database Architecture Comparison Worksheet	43	(1)
Venturing into the Great Unknown - New Database Architectures	44	(1)
Conclusion	45	(2)
Chapter 3 - Review Meetings	47	(15)
Oracle Database Design Review Meetings	47	(2)
Initial Overview of Proposed System	49	(2)
Logical Data Model Review	51	(1)
Designing for Performance	52	(1)
Setting up a Successful Test System in Oracle	53	(2)
Monitoring Performance During Testing	55	(1)
Performance Design Reviews	56	(1)
Preparation for Production Turnover	57	(1)
Post Production Turnover	58	(2)
Oracle Database Design Review Meetings - Conclusion	60	(1)
Conclusion	60	(2)
Chapter 4 - Oracle Database Administration	62	(27)
Oracle Software Installation	62	(1)
Migrating to Newer Oracle Releases	63	(4)
UNIX and LINUX Semaphores and Shared Memory	67	(4)
Semaphores	67	(3)
Shared Memory	70	(1)
Relinking Oracle8i and Oracle9i Products	71	(1)
Windows Services	72	(1)
Oracle Instance Administration	73	(1)
Oracle9i Persistent Initialization Parameter Files	74	(4)
Remote Startup/Shutdown	78	(1)
Multiple Buffer Pools	79	(2)
Specifying Default, Keep and Recycle Bufferpools in Oracle8 and Oracle8i	81	(1)
Specifying Default, Keep and Recycle Bufferpools in Oracle9i	82	(1)
Large Pool	82	(1)
Java Pool	83	(1)
Redo log Buffer Performance	84	(1)
Buffer Performance is critical to Good Oracle Performance	84	(1)
DBWR_IO_SLAVES vs DB_WRITER_PROCESSES	85	(2)
Conclusion	87	(2)
Chapter 5 - Oracle Database Objects	89	(73)
What Database Are You Working In?	89	(2)
Choosing a Database Block Size	91	(2)
Copying Databases Between Servers	93	(2)
Oracle Tablespaces	95	(3)
Temporary Tablespaces	96	(1)
Create Tablespace Temporary vs. Create Temporary Tablespace	97	(1)
Partitioning	98	(3)
Oracle 8 - Range Partitioning	101	(1)
Index Partitioning	102	(1)
Equi-Partitioned Objects	103	(1)
Local Indexes	103	(1)
Global Indexes	104	(1)
Oracle8i - Hash and Range/Hash Composite
Partitioning	104	(1)
Hash Partitioning	104	(1)
Combining Range and Hash Partitioning - Range/Hash Composite Partitioning	105	(1)
Oracle9i - List and Range/List Composite Partitioning	105	(3)
List Partitioning	106	(1)
Range/List Composite Partitioning	106	(2)
Which Partitioning Technique Do I Choose?	108	(2)
Oracle9i Tablespace Changes	110	(5)
Locally Managed System Tablespaces	115	(1)
Rollback Segments	116	(2)
When is the System Rollback Segment Used?	116	(1)
Rollback Segments and Transaction Processing Workloads	117	(1)
Batch and On-line Processing	118	(1)
Rollback Segments and Users - Who's Using What?	119	(1)
Oracle9i - Database Managed Undo Segments	120	(3)
Redo Logs	123	(1)
Checkpoint Not Complete	123	(2)
Resizing Redo Logs	125	(2)
Oracle Tables and Indexes	127	(1)
Space Utilization for Parallel Table Creates	128	(1)
Index-only Tables	128	(2)
Single Table Hash Clusters	130	(2)
Oracle9i External Tables	132	(4)
ALTER TABLE MOVE Statement	136	(1)
ALTER COLUMN RENAME	136	(1)
On-Line Table Reorganizations	137	(4)
PCTFREE and PCTUSED	141	(1)
Clustering Data in Tables	141	(1)
Merging Tables to Increase Query Performance	142	(1)
How Many Indexes Can I Build?	143	(1)
Parameters that Impact Index Usage	144	(1)
Index-Only Access	145	(2)
Index Rebuilds	147	(1)
Index Coalesce vs Index Rebuild	148	(2)
Function-Based Indexes	150	(1)
Bitmap Indexes	151	(2)
Optimizer and Bitmap Indexes	153	(1)
Concurrency and Bitmap Indexes	153	(1)
When to Use Bitmap Indexes	154	(1)
Bitmap vs B-Tree	155	(1)
Indexing Hints Tips and Tricks	155	(2)
Index Monitoring	157	(2)
Conclusion	159	(3)
Chapter 6 - Oracle Backup and Recovery	162	(23)
It's the Little Things That Bite You	162	(1)
Keep Your Skills Sharp	162	(1)
RELAX and Plan Your Attack	163	(1)
Don't Be Afraid to Ask Others	163	(1)
Instance Recovery and the Oracle Synchronization Process	164	(3)
Uncommitted Data on the Data Files	165	(1)
Committed Data Not On the Data Files	166	(1)
The Synchronisation Process	166	(1)
Roll Forward Phase	166	(1)
Roll Backward Phase	167	(1)
Exports and Recovery	167	(1)
V$RECOVERFILE	168	(1)
Watch the NOLOGGING Option	168	(1)
Striped File Systems	168	(1)
Data Files and Redo Logs	169	(1)
Redo Log and Control File Multiplexing	169	(1)
OCOPY for Windows	169	(1)
Hot Backup Scripts for Windows	169	(2)
Hot Backup Scripts for UNIX	171	(2)
Oracle9i - Lazy Checkpointer	173	(2)
Recovery Manager	175	(7)
Recovery Catalog	177	(1)
Recovery Manager Backup Types	177	(2)
Backup Sets	178	(1)
Image Copies	178	(1)
Parallel Backup and Recovery	179	(1)
Multiplexed Backup Sets	179	(1)
Backup/Recovery Reports	179	(1)
Database Recovery	180	(1)
RMAN Examples	180	(2)
db_verify	182	(1)
Conclusion	182	(3)
Chapter 7 - Tuning and Performance	185	(34)
Be careful with the ANALYZE command	185	(1)
Finding Problem Queries	186	(2)
Optimizer Plan Stability	188	(1)
Pinning Objects in the Shared Pool	189	(1)
PCTFREE and PCTUSED	190	(1)
Caching Tables	190	(1)
Clustering Data in Tables	191	(1)
Merging Tables to Increase Query Performance	191	(1)
Hints	192	(1)
Parallel Hints	193	(1)
Performance Testing	193	(1)
Parallel Query	193	(1)
Tuning Oracle on Windows	194	(1)
Tuning Pack	194	(1)
Direct Load Inserts	194	(2)
Parallel DML Processing	196	(2)
Materialized Views	198	(1)
Database Resource Management	199	(1)
STATSPACK	200	(2)
V$ TABLES vs. Oracle BSTAT/ESTAT and STATSPACK	202	(1)
Segment-Level Performance Statistics Collection	202	(2)
Performance Tuning Intelligent Advisories	204	(1)
Optimizer Dynamic Sampling	205	(2)
Data Segment Compression	207	(2)
Using Explain Pan to Determine Access Paths	209	(4)
Explain Plan Output	213	(1)
SQL*PLUS AUTOTRACE	214	(1)
High Water Mark and Table Scans	214	(1)
Allocating too Much Memory to the Shared Pool and Data Buffers	215	(1)
Conclusion	216	(3)
Chapter 8 - Miscellaneous Oracle Information	219	(26)
The Foot Rule of Thumb	219	(1)
Monitor By Day So You Don't Get Called at Night	220	(3)
Monitoring Space Utilization and Performance Statistics Historically	223	(2)
Latches and Enqueues	225	(1)
Deadlock Detection	226	(1)
Unindexed Foreign Keys and Locking Problems	227	(3)
Using PUPBLD	230	(1)
Copying databases between servers	231	(1)
Oracle9i - Resumable Space Allocation	232	(2)
Oracle9i - Flashback Query	234	(4)
Full Database Exports	238	(1)
Large Table Imports	238	(1)
Compressing Export Output Files in UNIX	239	(1)
Terminating Oracle Processes (Threads) in Windows Systems	239	(1)
Truncating vs Deleting	239	(1)
Copy Command in SQL*PLUS	240	(1)
Displaying Time in Milliseconds	240	(1)
!, $ and Host Command Differences	240	(1)
Learn Command Line BEFORE Using "Sissy GUI Tools" Like Oracle Enterprise Manager	241	(1)
Don't Write Scripts	241	(1)
Don't' Write Iterative SQL Statements - Generate SQL with SQL	241	(1)
Input Truncated to 9 Characters	242	(1)
Conclusion	242	(3)
Chapter 9 - Evaluating Third-Party Products	245	(12)
Initial Analysis	245	(1)
Determine Impact to the Information Technology Support Infrastructure	246	(1)
Analysis Evaluation	247	(1)
Obtain Business Unit and IT Management Commitment	248	(1)
Create Evaluation Team	249	(1)
Locate Potential Vendors	250	(1)
Initial Elimination	251	(1)
Vendor Evaluation	252	(2)
Communicate Results	254	(1)
Conclusion	255	(2)
Chapter 10 - Ease of Administration	257	(13)
Good Documentation is Essential	257	(4)
Follow OFA Naming Conventions	261	(1)
Proceduralize Administrative Support for the Application Development Process	262	(1)
Proceduralize the Change Request Process	262	(3)
Create and Standardize Monitoring and Administration Scripts	265	(1)
Repeatable Processes	266	(1)
Create Service Level Agreements	266	(1)
DBA Report Cards and the 360-Degree Review Process	267	(1)
Corrective Action Reports	267	(1)
Conclusion	268	(2)
Chapter 11 - Oracle Database Security	270	(15)
Protecting Data Requires More than just Protecting the Production Database	270	(2)
Identifying Granted Privileges	272	(2)
Accounts Created During Database Creation	274	(2)
Wrapping PL/SQL Programs	276	(1)
Using OPS$ Accounts	276	(1)
Using Security Profiles	277	(2)
SYS and SYSTEM Passwords	279	(1)
GRANT ANY OBJECT Privilege	280	(1)
Administrative User Auditing	281	(1)
Moving the AUD$ Table	282	(1)
Conclusion	283	(2)
Chapter 12 - Certification Test Preparation	285	(28)
Introduction	285	(1)
Oracle Certified Associate Tests	286	(10)
Exam 1Z0-007 - Introduction to Oracle9i SQL	286	(2)
Exam 1Z0-031 - Oracle Database Fundamentals I	288	(8)
Oracle Certified Professional Tests	296	(13)
Exam 1Z0-032 - Oracle Database Fundamentals II	296	(7)
Exam 1Z0-033 - Oracle Database Performance Tuning	303	(6)
Conclusion	309	(2)
Book Conclusion	311	(2)
Index	313	(3)
About the Author	316