X

Alejandro Vargas' Blog

  • March 29, 2006

RAC Diagnostics Script

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

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:

Join the discussion

Comments ( 1 )
  • Chandra Wednesday, April 11, 2007
    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
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.