OCP Instructors Guide for Oracle DBA Certification A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques Christopher T. Foot ISBN: 0-9744355-3-8 Library of Congress Number: 2003096523 336 pages - Perfect bind 9x6 Shelving: Database/Oracle Oracle In-Focus Series # 14 Retail Price $27.95 / £17.95 Key Features About the Authors Table of Contents Errata Reader Comments Order now and get immediate online access to the code depot! Only $19.95 (30% off) Written by one the world's top Oracle instructors, this book utilizes Chris Foot's substantial knowledge of Oracle DBA training to create this unique guide to teaching Oracle DBA certification. This book is for Oracle OCP DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. The book also contains a wealth of general information on administering Oracle database environments and is an excellent resource for day-to-day database administrators. * Provides the OCP certification instructor with detailed learning content. * Guides the OCP instructor through the important OCP test areas. * Contains valuable tips and techniques for making students succeed in passing their OCP exam. * Focuses on the important OCP conceptual areas. * Provides practical and applied teaching techniques for OCP instructors. * Includes expert advice on performance and tuning, backup and recovery, Oracle internals and general database administration guidelines. * Provides dozens of hints and tips that aren't covered by other Oracle books currently on the market including these topics: - The pros and cons of the most commonly used Oracle platforms including UNIX, LINUX and Windows. - Database design review meetings – The key to successful application development projects. - Dozens of best practices that are guaranteed to increase the quality of day-to-day support activities and reduce the amount of time spent administering Oracle databases 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 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$l Para obtener mas informacion, visite la pagina del producto. Este producto esta en nuestro catalogo desde sábado 30 agosto, 2003. Clientes que compraron este producto, tambien han comprado Advanced Oracle Utilities Tuning Half-Pack Oracle 11g New Features You're Fired! Advanced Oracle SQL Programming Oracle Tuning:The Definitive Reference Compras 1 x  Easy HTML-DB Oracle Application Express 30.85EUR Fabricante -  Pagina de Rampant TechPress -  Otros productos Notificaciones Notifiqueme de cambios a OCP Instructors Guide for Oracle DBA Certification Diselo a un Amigo   Envia esta pagina a un amigo con un comentario. Comentarios Escriba un comentario para este producto Idiomas Monedas US DollarDeutsche MarkSpanish PesetaEuro   lunes 06 septiembre, 2010     6951625 peticiones desde jueves 30 enero, 2003   P. O. Box 511 Kittrell, NC, 27544 SAN: 2 5 5 - 1 3 1 4