Ships from: Phoenix, MD
Usually ships in 1-2 business days
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.
| 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 | |
| DBWR_IO_SLAVES vs DB_WRITER_PROCESSES | 85 | |
| 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 | |
| V$RECOVERFILE | 168 | |
| 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 | |
| PCTFREE and PCTUSED | 190 | |
| 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 | |
| STATSPACK | 200 | |
| V$ TABLES vs. Oracle BSTAT/ESTAT and STATSPACK | 202 | |
| 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 | |
| SQL*PLUS AUTOTRACE | 214 | |
| 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 |
Overview
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,...