ISBN:  0-9823061-2-1 ISBN13: 978-0-9823061-2-3 Library of Congress Number: 2009934294 200 pages Perfect bind - 9x7 PD 0511 Shelving:  Databases/Oracle Oracle In-Focus Series #35

Exploring Oracle Internals Tips and Tricks for the Oracle DBA Ben Prusinski Retail Price $29.95 /  £24.95  Order now at 30% off and get access to the code depot! Only $20.95         Key Features About the Author Table of Contents Index Reader Comments Errata Until now, Oracle database internals have been available previously only to internal Oracle support engineers and not available to outside of the Oracle Corporation database internals support group. This text explains hot issues for resolving the most difficult performance and recovery issues for Oracle 11g databases. It will allow the experienced Oracle professional to become an expert on how the Oracle database engine really works and provide the Oracle beginner with the solid core knowledge of the theory and practice behind the Oracle database.

Most experienced Oracle DBAs are familiar with the standard utilities found within the Oracle database server environment such as RMAN, export and import and Grid Control. However, when it comes down to how the actual database engine works under the hood, the internal workings of Oracle are poorly documented or hidden from plain view of the working DBA. Are you a senior level Oracle professional who wants to learn the secret workings of the Oracle 11g database engine to be able to solve tricky database issues?   This timely and expert guide will cover many of the little known and undocumented features within the newest release of Oracle database for Oracle 11g. It will be a perfect capstone to mastering the keys to the kingdom of the Oracle 11g engine. Move from the average Oracle DBA to become an expert level DBA with the help of this exciting new guide from an Oracle guru!  Topics will include a detailed discussion of the latest Oracle 11g database internals which previously have been undocumented and internal to only the Oracle server development team. In addition, tools and utilities that have been previously neglected such as how to use internal tools for database issues such as oradebug and tkprof will be explored for tuning difficult issues with the Oracle 11g database. This book distills the very complex nature of Oracle 11g database internals using undocumented tools and features that have not been covered so that database professionals can gain mastery over solving the most difficult and challenging issues for Oracle 11g.

*  Get real world advice for resolving the most difficult Oracle 11g performance and recovery issues.   *  Covers little known and undocumented Oracle 11g features.   *  Use internal tools for database issues - including oradebug and tkprof.   *  Take your skill level from average to expert with the help of this Oracle guru.

About the Author:

Ben Prusinski

Ben Prusinski has 10 years of full-time experience as a database administrator and has written numerous articles and white papers on database management. Ben is also an active member of the San Diego and Orange County Oracle and IBM DB2 User Group community, and he has published various articles for customers and user groups on data management. Ben has been working with databases including Oracle, Microsoft SQL Server, IBM DB2 UDB, Informix, MySQL, and PostgreSQL since 1996 and has accumulated over a decade of practical knowledge and experience with complex database migrations and support on how to best achieve results with large database migrations to the Oracle platform. Ben enjoys training in martial arts and tai chi as well as travel to exotic locations in his free time outside of working on Oracle databases.  He has traveled to over 15 countries in Latin America and Asia and has a passion for learning new foreign languages as well as cultural traditions.

Table of Contents:

Chapter 1:  Introduction to Oracle 11g Database Insider Secrets   Chapter 1:  Introduction Chapter 2:  Oracle 11g Memory Chapter 3:  Locks with Oracle 11g Chapter 4:  Latches and Oracle 11g Chapter 5:  Hidden and Undocumented Oracle 11g Parameters Chapter 6:  Exploring V$ and the Oracle 11g Data Dictionary Chapter 7:  X$ Tables for Oracle 11g Appendices New Features Overview for Oracle 11g Release New Feature:  Invisible Index Partitioning New Features System Partitioning Interval Partitioning Virtual Column Based Partitioning Reference Partitioning New Feature:  Active Data Guard New Feature: ADR Monitoring Tools Automatic Memory Management Oracle 11g Internals Summary The Oracle 11g Kernel Architecture Undocumented Tools Poorly Documented Tools Summary   Chapter 2:  Oracle 11g Database Insider Secrets:  Memory   Oracle 11g Memory Oracle 11g Database Architecture Inside the Oracle 11g System Global Area (SGA) Automatic Memory Management (AMM) Oracle 11g Advisors for SGA and PGA Memory Shared Pool Streams Pool Large Pool Java Pool Other Components Within the Oracle 11g SGA Inside the Oracle 11g Program Global Area (PGA) Semaphores and Oracle 11g Mutexes and Oracle 11g Wait Events and Mutexes for Oracle 11g How Mutexes in Oracle 11g Differ from Operating System Mutexes Windows Memory and Threads and Oracle 11g UNIX and Linux Shared Memory and Oracle 11g Stack Traces for Oracle 11g Shared Memory Understanding the Oracle 11g Memory Call Stack Summary   Chapter 3:  Insider Secrets:  Locks and Oracle 11g   Introduction What Are Locks? Database Isolation Levels and Serialization for Transactions Types of Locks within Oracle 11g DML Locks Lock Management and Escalation Lock Management for Oracle RAC Environments Locking Mechanism for Oracle 11g RAC Enhancements to Lock Management with Oracle 11g Serializing Locks with Oracle 11g Locking Tables Explicitly Useful Tips and Tricks for Locking Problems Oracle 11g Database Waits: Insufficient  ITL Slots Avoiding Deadlock Conditions Lock Contention Issues and Solutions Summary   Chapter 4:  Insider Secrets:  Latches   What are Latches? How Do Latches Work with Oracle 11g? Types of Latches within Oracle 11g Exploring Latches with Dynamic Performance Views How Latches Differ From Locks Tips for Latch Contention Issues with Oracle 11g Tuning Latch Contention Issues for LRU Chain Latches Additional Tips for Tuning Oracle 11g Latches Summary

Chapter 5:  Hidden Parameters in Oracle 11g   Purpose of Hidden Parameters for Oracle 11g How to Locate Hidden Parameters for Oracle 11g Explanation of Key Hidden Parameters for Oracle 11g New Features for 11g and Hidden Parameters Summary   Chapter 6:  Exploring New v$ Tables in Oracle 11g   New Features for the v$ Tables and Oracle 11g Data Dictionary Purpose of v$ Views for Oracle 11g Categories for Oracle 11g Database Administration with v$ Views General Oracle 11g Database Administration Performance Tuning Oracle 11g Comprehensive Listing of Oracle 11g Dynamic v$ Performance Views Investigating Oracle 11g Internals with V$ Views Scripts and Tips for v$ and Data Dictionary - Oracle 11g Summary   Chapter 7:  Inside the x$ Tables of Oracle 11g   Classification of x$ Tables Exploring Oracle 11g Database Internals with x$ Tables Oracle 11g New Features – Useful x$ Tables Using the X$ Tables for Oracle 11g Analysis             Scripts using X$ Tables with Oracle 11g Summary   Book Conclusion   Appendix A:  Internal Tools for Oracle 11g   DBX Using DBX for Debugging Oracle Using DBX for Tracing Oracle 11g Memory Process: Truss   Appendix B:  Oracle 11g Trace Events   Oracle 11g Database Trace Level Events   Appendix C:  ORA-0600 Troubleshooting   Appendix D:  References   Chapter 1: Introduction Chapter 2: Oracle 11g Memory Chapter 3: Database Locks Chapter 4: Database Latches Chapter 5: Hidden Oracle 11g Parameters Chapter 6: V$ Views Chapter 7: X$ Tables for 11g Appendix A: Oracle 11g Database Internal Toolkit Appendix B: Oracle 11g Trace Events Appendix C: ORA-0600 Appendix E: Strace Appendix F: Using GDB for Oracle 11g Appendix G: Orakill for Windows and Oracle 11g   Appendix E:  Using Strace   Strace for Oracle 11g and Linux Command Options for Strace with Linux for Oracle 11g   Appendix F:  Using GDB with Oracle 11g   Introduction to GDB with Oracle 11g Oracle 11g Trace Stack with GDB   Appendix G:  Orakill for Windows   Orakill for Windows

Index:

$ $database_block_corruption               / /dev/shm          _ _diag_hm_tc_enabled _hang_detection _hang_resolution _hm_analysis_oradebug_node_dump_level _hm_analysis_output_disk 1 11g ASM 11g Concurrency and SQL Tuning 11g Data Guard 11g Health Monitor 11g Memory Tuning              11g Streams 11gRAC A ACID model ADR Memory Monitor adrci adrci> show home alert.log  alert.log file alter index…invisible alter index…visible               archive control latches attach Automatic Diagnostic Database Monitor Automatic Diagnostic Repository automatic segment space management              Automatic Workload Repository B background_dump_dest Backup and Recovery block media recovery bt C cache buffers chain latch cache buffers LRU chain latch             catalog.sql catldr.sql                core_dump_dest Cost Based Optimizer cpu_count cursor:mutex cursor:pin              D data dictionary data dictionary cache Data Guard Data Recovery Advisor database buffer cache database locks db_block_buffers db_block_hash_buckets db_block_lru_latches db_block_size db_cache_size dba_extents dba_hist_latch dba_objects.object_id dba_segments dbms_repair dbms_xplan DBVERIFY DBWR DBX ddl_lock_timeout deadlock diag_adr_auto_purge diag_adr_enabled diag_adr_test_param diag_hm_rc_enabled diagnostic_dest dirty reads DML locks dra_bmr_number_threshold dra_bmr_percent_threshold dra_enable_offline_dictionary dumpsga                E EM Support Workbench Enterprise Manager              exclusive                explicit locking F fk_empno               flashback memory buffer fuzzy reads G GDB        global cache services global enqueue services global lock conflicts gv$dlm_latch gv$latch gv$lock  gv$resource

H health monitor help help extended hm_analysis_oradebug_sys_dump_level I index-organized tables initrans   interested transaction list     interprocess communication model interval partitioning invisible index ipc ipcs ips create package                ips show        J Java pool buffer     K Kernal Database Layers        Kernel Access Kernel Cache Kernel Compilation               Kernel Data Kernel Distributed Transaction Kernel Execution Kernel Generic Kernel Locking Kernel Query Kernel Security Kernel Services Kernel Transactions kgl_latch_count kgllkreq  kglnaobj L large pool buffer large_pool_size latch contention issues latch hit ratio latch request mode               latch_wait_posting                latches Latches level library cache library cache latch local lock conflicts Locally Managed Tablespaces lock escalation lock table                locks log.xml   log_buffer               log_small_entry_max_size long wait latches LRU LRU chain latches M Maximum Availability Architecture maxtrans                memory management Memory Management Units memory_max_target memory_target mutex mutex_type mutexes  N Network Attached Storage NFS configuration nowait no-wait mode null          O optimizer_use_invisible_indexes ORA-0600 Oracle Call Interface Oracle SGA Orakill     P pct_free  pct_used                pga_aggregate_target pga_target phantom reads physical address area pk_emp invisible pmap PMON process Program Global Area prop_old_enabled                pstack Q qslice.exe               Quickslice

R Recovery Manager                redo allocation latches Redo copy latch    redo copy latches redo log buffer       reference partitioning reference_emp result cache row cache objects latch row exclusive row share               row-level locks S serialization mechanisms sga_max sga_max_size sga_target share share locks share row exclusive shared pool shared pool latches              Short wait latches show alert spin count spin_count SQL*Plus                SQL*Plus interface                statistics_level Storage Area Network Strace tool Streams Pool streams_pool_size                SYS level privileges              sysresv   System Global Area system partitioning               T table locks Trace Level Events transaction locks Truss U undocumented parameters User Program Interface user_dump_dest user_part_tables user_tab_partitions V v$ dynamic performance views v$ views v$db_cache_advice v$diag_info v$fixed_table v$fixed_view_definition v$ir_repair v$java_pool_advice v$javapool v$latch    v$latchholder v$latchname v$library_cache_memory v$librarycache       v$lock     v$memory_dynamic_components v$memory_target_advice v$mutex_sleep       v$mutex_sleep_history         v$pgastat v$rowcache v$segment_statistics            v$sga_target_advice             v$shared_pool_advice         v$streams_pool_advice       virtual      virtual column based partitioning        W wait events willing-to-wait request mode Windows Virtual Memory Manager X x$ tables x$dbgalertext x$dbgdirext x$diag_info x$ir_repair_option x$kcbfwait x$kgllk    x$kglpn x$kq        x$kqfvi    X$KS       x$ksmsp x$ksppi  x$kzspr   x$kzsrt    Y yearly_sal

Reviews:

From the series Editor:

Errata: