Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 


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!

Key Features

*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

 

$

$oracle_home/rdbms/admin

 

/

/c

/etc/hosts

/rdbms/admin

/v

/x

 

 

A

ADRCI command tool

ADRCI interface

alert log reporting

alert.log  

ALL

all_source

attach_session

Automatic Diagnostic Repository (ADR)

Automatic Memory Management

Automatic SQL Tuning Advisor

AutoTrace

 

B

background_dump_dest

BASIC

BBED

bbed parfile

BBED utility

 

C

check_events.sql

close_trace

Cluster Synchronization Services

core_dump_dest

Cost Based Optimizer

count

 

D

Database Hang Analysis

datafile

dba_stat_extensions

dbms_auto_task_admin

dbms_debug

dbms_debug.initialize

dbms_debug.set_breakpoint

dbms_profiler

dbms_sqltune

dbms_sqltune _plans

dbms_sqltune _statistics

dbms_sqltune_binds

dbms_stats

dbms_system

dbms_trace

dbmspb.sql

DBVERIFY

diagnostic_dest

dump

dumplist

dumpsga

 

E

edit mode

EM Support Workbench

emacs

Enterprise Manager Grid Control

examine

export_database_prefs

 

F

file_id

find

 

G

get_param

 

H

hanganalyze

heapdump trace

help

help extended

 

I

ign state

ign_dump state

import_database_prefs

in_hang state

interconnect operations

interprocess communications

ips create package

ips show

 

L

leaf

leaf_nw

listener.ora

listfile

log.xml  

LSNRCTL

lsnrctl services

lsnrctl status

M

map

map /v

max_dump_file_size

 

N

nleaf

 

O

oracle base

oracle home

Oracle RAC cluster registry

Oracle RAC Clusterware

oracle_sid

ORADBX

Oradebug

oradebug dump errorstack

 

P

PADDR

parallel_min_servers

parfile

ping

PING

plsql_profiler_units

processstate dump

procstat

profload.sql

 

R

raw dump

read_ev

resume

 

S

security identifier

SERIAL#s

set autotrace off

set autotrace on

set block

set blocksize

set count

set dba

set file

set filename

set ibase

set mode

set offset

set_global_prefs

setmypid

setospid

SH schema account

sh.products

show

show all

show home

SID

SPID

SPID (Service Profile Identifier)

SQL trace

SQL Tuning Advisor

SQL*Plus

stale_percent

statistics_level

suspend

 

T

test.log listfile

text trace

time_limit

TKPROF

tnsnames.ora

TNSPING

trace feature

trace name context off

tracefile_name

 

U

unlimit

user_dump_dest    

user_name

 

V

v$datafile

v$diag_info

v$process

v$session

v$session_wait

verify

vi

 

X

xml alert.log

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks