Script to Collect RAC Diagnostic Information (racdiag.sql)-白红宇

Script:

                               
-- NAME: RACDIAG.SQL
-- SYS OR INTERNAL USER, CATPARR.SQL ALREADY RUN, PARALLEL QUERY OPTION ON
-- ------------------------------------------------------------------------
-- AUTHOR:
-- Michael Polaski - Oracle Support Services
-- Copyright 2002, Oracle Corporation
-- ------------------------------------------------------------------------
-- PURPOSE:
-- This script is intended to provide a user friendly guide to troubleshoot
-- RAC hung sessions or slow performance scenerios. The script includes
-- information to gather a variety of important debug information to determine
-- the cause of a RAC session level hang. The script will create a file
-- called racdiag_.out in your local directory while dumping hang analyze
-- dumps in the user_dump_dest(s) and background_dump_dest(s) on all nodes.
--
-- ------------------------------------------------------------------------
-- DISCLAIMER:
-- This script is provided for educational purposes only. It is NOT
-- supported by Oracle World Wide Technical Support.
-- The script has been tested and appears to work as intended.
-- You should always run new scripts on a test instance initially.
-- ------------------------------------------------------------------------
-- Script output is as follows:
set
echo 
off
set
feedback 
off
column
timecol new_value 
timestamp
column
spool_extension new_value suffix
select
to_char(sysdate,
'Mondd_hhmi'
) timecol,
'.out'
spool_extension 
from
sys.dual;
column
output
new_value dbname
select
value || 
'_'
output
from
v$parameter 
where
name
= 
'db_name'
;
spool racdiag_&&dbname&
          
        
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277055