ISBN: 0-9744355-3-8 ISBN 13 978-0974435534 Library of Congress Number: 2003096523 336 pages: Perfect bind 9x6 PD 404 Shelving: Database/Oracle Oracle In-Focus Series # 14

OCP Instructors Guide for Oracle DBA Certification A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques By Christopher T. Foot    Retail Price $27.95 / £17.95  Order now and get immediate online access to the code depot! Only $19.95   (30% off)       Key Features About the Authors Table of Contents Index Reader Comments Errata       Get the Easy Oracle Pack Five books for $59.95 - A $110.00 value Easy Oracle Jumpstart $27.95 Easy Oracle PHP $27.95 Oracle DBA Made Simple (eBook) $19.95 Easy Oracle SQL $16.95 Easy Oracle PL/SQL Programming $16.95

About the Author:

Chris Foot   Christopher T. Foot is an Oracle certified senior-level instructor, technical sales specialist and database architect for Contemporary Technology. Chris has fifteen years' experience with database Technologies and is a regular speaker at the International Oracle Users Group and Oracle Open World conferences Contemporary Technologies Inc. is a leading provider of Oracle products and services.

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

Index:

A audit_file_dest audit_sys_operations audit_trail   B BSTAT  buffer_pool_keep buffer_pool_name  D Data buffer cache db_block_buffers db_cache_size db_create_file_dest db_keep_cache_size db_nk_cache_size  db_recycle_cache_size  db_verify   db_writer_processes dba_col_privs dba_data_files dba_role_privs  dba_roles         dba_sys_privs dba_tab_privs dba_tablespaces dba_temp_file dba_undo_extents dba_users  dbms_flashback dbms_redefinition  dbms_shared_pool.keep dbms_stats   DBWR   dbwr_io_slaves  E ESTAT      F failed_login_attempts     fast_smart_mttr_target    I initial   initrans

J java_pool_size    L large_pool_size LGWR local Log buffer log_buffer log_checkpoint_interval log_checkpoint_timeout  M max_sga_size  maxtrans  O optimizer_dynamic_ sampling optimizer_index_caching optimizer_index_cost_ adj optimizer_mode  ORA-27100 ORA-27102 ORA-27123 ORA-27125 ORA-7250 ORA-7251 ORA-7252  ORA-7279        ORA-7339        oracle_loader  oracle_priority oracle_sid        P parallel_automatic_ tuning  password_grace_time password_life_time  password_lock_time  password_reuse_max  password_reuse_time password_verify_ function -pfile PFILE pga_aggregate_target  proxy_users

Q queue_privs  R remote_os_authent  role_role_privs role_sys_privs   role_tab_privs Rollback/Undo segments S session_privs session_roles sga_max_size shared_pool_size  shmmax  shmmin shmmni  shmseg sort_area_retained_size sort_area_size spfile  SPFILE statistics_level U undo_management   undo_retention undo_tablespace use_stored_outlines   V v$backup_device v$datafile v$log v$log_history v$object_usage v$recoverfile v$rollstat  v$segment_statistics v$segstat v$segstat_name v$shared_pool_advice v$tempfile

We also offer Oracle OCP books Oracle OCP test, Oracle OCP testing, Oracle OCP certification, Oracle OCP Exam, OCP, OCP Exam, OCP test, OCP certification, OCP questions, OCP exam questions, OCP test questions and OCP certification questions.