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


An instructor’s guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings,...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (4) from $2.59   
  • New (1) from $50.01   
  • Used (3) from $2.59   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2011

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Brand new and unread! Join our growing list of satisfied customers!

Ships from: Phoenix, MD

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by
Sending request ...


An instructor’s guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Read More Show Less

Product Details

  • ISBN-13: 9780974435534
  • Publisher: Rampant Techpress
  • Publication date: 4/28/2004
  • Series: Oracle In-Focus series
  • Pages: 336
  • Product dimensions: 6.00 (w) x 9.00 (h) x 0.81 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

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

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)