Oracle - DB調査(ロック、ハングなど)

-- DB調査に必要なデータ 

-- RACの場合、全ノードにて 以下の SQL 文の検索結果情報（１分おきに３回）

alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

alter session set timed_statistics = true;

alter session set max_dump_file_size = UNLIMITED;

column log_date new_value log_date_text noprint

select to_char(sysdate,'yyyymmddhh24miss') log_date from dual;

spool ora_&log_date_text

set term on

set wrap on

set trimspool on

set pagesize 1000

set linesize 2000

set numwidth 10

set echo on

select to_char(sysdate) start_time from dual;

set feed 1

select * from v$process;

select * from v$session;

select * from v$session_wait;

select * from v$lock;

select * from v$locked_object;

select * from v$latch;

select * from v$latchholder;

select * from v$resource_limit;

select * from v$ges_blocking_enqueue;

spool off