RAC Diagnostics Script (Alejandro Vargas' Blog)

RAC Diagnostics Script

By alejandro.vargas on March 29, 2006 2:50 AM

Oracle Support provides several tools for RAC diagnostics. 
One of them is racdiag.sql available through metalink.

Note: 135714.1 Script to Collect RAC Diagnostic Information (racdiag.sql)

This script is broken up into different SQL statements that can be used 
individually.  Each SQL statement adds information to help in debugging an 
RAC hang/severe performance scenerio.  

The script provide the following information:

- WAITING SESSIONS
- EVENT PARAMETER LOOKUP
- GES LOCK BLOCKERS
- GES LOCK WAITERS
- LOCAL ENQUEUES
- LATCH HOLDERS
- LATCH STATS
- No Wait Latches
- GLOBAL CACHE CR PERFORMANCE
- GLOBAL CACHE LOCK PERFORMANCE
- RESOURCE USAGE
- DLM TRAFFIC INFORMATION
- DLM MISC
- LOCK CONVERSION DETAIL
- TOP 10 WRITE PINGING/FUSION OBJECTS
- TOP 10 READ PINGING/FUSION OBJECTS
- TOP 10 FALSE PINGING OBJECTS
- INITIALIZATION PARAMETERS
- TOP 10 WAIT EVENTS ON SYSTEM
- SESSION/PROCESS REFERENCE
- SYSTEM STATISTICS
- CURRENT SQL FOR WAITING SESSIONS
- WAITING SESSIONS:

Permalink

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/4397

Comments (1)

Chandra:

Hi Alejandro,

First off, please accept my congratulations for maintaining a repository of wonderful technical information and tips. You have put in real useful information....

Just have a quick question on your post dated 3/29 (RAC Diagnostics Script)..I understand from other professionals and messages posted at various mail groups, that we are not supposed to make publicly available contents of metalink notes on websites (hosted not by Oracle itself). So wondering, if it is ok for you to do so. Just a thought.

Thanks
Chandra

Posted by Chandra | April 11, 2007 7:12 AM

Posted on April 11, 2007 07:12

Alejandro Vargas' Blog