ISBN 10:  0-9823061-4-8 ISBN 13: 978-0-9823061-4-7 Library of Congress Number: 2009930094 136 pages Perfect Bind - 9x7 Publication Date: 0611 Shelving:  Databases/Oracle Oracle In-Focus Series #34

Oracle Debugging A Comprehensive Guide to Debugging Solutions Ben Prusinski Retail Price $14.95 /  £9.95   Order now at 30% off and get access to the code depot! Only $10.49 (30% off)         Key Features About the Author Reader Comments Table of Contents Index Topics Errata

Experienced database professionals who work on Oracle database systems often have to solve difficult issues for Oracle performance and hang analysis. Due to the need to perform these critical tasks and lack of support from existing Oracle documentation, Oracle professionals will benefit from learning how to leverage the power of the hidden and undocumented tools within Oracle such as the oradebug utility. Using these poorly or little known tools within Oracle, readers will be able to quickly diagnose problems and perform root cause analysis of such issues as ORA-0600 database errors and database hang issues. It will furthermore provide coverage of these features that allow the Oracle DBA to dig into the core of the Oracle database internal structures to resolve the most challenging issues for database management. As such, this timely book will provide the latest features for Oracle 11g and 10g environments in terms of how to quickly diagnose and fix the toughest database problems.

Expert                secrets &               hidden tips                & tricks! *Use ORADEBUG to Trace A Sessions SQL. * Find Parallel SQL Processes Using ORADEBUG. * Learn how to determine the Events Set in a System. * Use ORADEBUG to Look at Library Cache States.

About the Author:

Ben Prusinski

Ben Prusinski is an Oracle Certified Professional and Oracle ACE with more than 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 IOUG, OAUG, and SROAUG user group communities. As a top Oracle expert, Ben is a frequent speaker and presenter at major technical conferences including Oracle OpenWorld, IOUG, and CLOUG.  Ben has worked with databases including Oracle, Microsoft SQL Server, IBM DB2 UDB, and MySQL since 1996.  As a certified Oracle RAC expert, Ben has designed robust architectures for high availability with Oracle RAC, Streams, and Data Guard for Oracle E-Business Applications and data warehouse environments. Furthermore, he has accumulated over a decade of practical knowledge and experience with complex database migrations and support, focusing mainly on how to best achieve results with large database migrations to the Oracle platform.

Table of Contents:

Chapter 1:  Introduction to Oracle 11g Debugging A Comprehensive Guide to Debugging New Features for Debugging Oracle 11g Undocumented Tools Poorly Documented Tools Summary   Chapter 2:  Performance Tuning Tools for Oracle 11g AutoTrace SQL Trace TKPROF TKPROF Syntax SQL Tuning Packages for Oracle 11g Dbms_stats with Oracle 11g Summary   Chapter 3:  Using the Oradebug Utility for Oracle 11g What is Oradebug? New Features for Oradebug with Oracle 11g Tracing Errors with Oradebug Using Oradebug to Determine the Events Set in Oracle 11g Viewing Oracle RAC Events with Oradebug Dumping Memory with Oradebug Dumping SGA Memory for Oracle 11g with Oradebug Using Oradebug to Examine the Library Cache State for Oracle 11g Dumping PGA Memory for Oracle 11g Using Oradebug Using Oradebug for Taking Processstate Dump with Oracle 11g Using Oradebug for Debugging Memory Issues for Oracle 11g Using Oradebug for Database Hang Analysis with Oracle 11g How to Suspend and Resume Processes with Oradebug Tuning SQL with Oradebug Using Oradebug to Trace SQL for User Session Tracing Parallel SQL Processes for Oracle 11g Syntax and Options for Oradebug Summary Chapter 4:  Network Troubleshooting for Oracle 11g Common Oracle 11g Network Errors PING TNSPING The LSNRCTL Utility for Oracle 11g Summary   Chapter 5:  Debugging SQL and PL/SQL DBMS_DEBUG DBMS_PROFILER Summary   Chapter 6:  Core Analysis with BBED for Oracle 11g What is BBED? How to Use the BBED Utility with Oracle 11g Configuration Steps for Using BBED with Oracle 10g Introduction to Using BBED Using BBED Commands for Oracle 10g/11g How to Check for Block Corruption Using BBED for Oracle 10g/11g Syntax for BBED The Find Command (f) Summary   Appendix:  References Chapter 1: Introduction to Oracle 11g Debugging Chapter 2: Performance Tuning Tools for Oracle 11g Chapter 3: Using The Oradebug Utility for Oracle 11g Chapter 4: Network Troubleshooting for Oracle 11g Chapter 5: Debugging SQL and PL/SQL Chapter 6: Core Analysis with BBED for Oracle 11g

  INDEX