GeezerVison is showing github.com — cscripts/cs_hanganalyze.sql at master · oradrs/cscripts

Expand file tree

cs_hanganalyze.sql

Copy path

More file actions

executable file

32 lines (32 loc) · 910 Bytes

Copy path

executable file

32 lines (32 loc) · 910 Bytes

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

----------------------------------------------------------------------------------------

-- File name: cs_hanganalyze.sql

-- Purpose: Generate Hanganalyze Trace

-- Author: Carlos Sierra

-- Version: 2020/12/06

-- Usage: Execute connected to CDB or PDB.

-- Example: $ sqlplus / as sysdba

-- SQL> @cs_hanganalyze.sql

-- Notes: Developed and tested on 12.1.0.2.

---------------------------------------------------------------------------------------

ALTER SESSION SET tracefile_identifier = 'iod_hanganalyze';

COL trace_file NEW_V trace_file;

SELECT value trace_file FROM v$diag_info WHERE name = 'Default Trace File';

oradebug setmypid

oradebug unlimit

oradebug hanganalyze 3

oradebug tracefile_name

HOS cp &&trace_file. /tmp