FilesExpand file tree

 main

/

db_hang.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

24 lines (18 loc) · 716 Bytes

 main

/

db_hang.sql

Copy path

Top

File metadata and controls

• Code
• Blame

24 lines (18 loc) · 716 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

--

-- Author: Prashant 'The FatDBA' Dixit

--

-- Create system state dump, hanganalyze and ashdumps

sqlplus / as sysdba

oradebug setmypid

oradebug unlimit

oradebug hanganalyze 3

oradebug dump ashdumpseconds 30

oradebug dump systemstate 266

oradebug tracefile_name

-- he ASH information can be dumped to trace file even if it cannot be collected in the database.

-- that will gather ASH from latest 30 seconds, and the trace file will even have the sqlldr ctl file to load it in an ASH like table.

oradebug dump ashdumpseconds 30

-- a ‘preliminary connection’ that does not create a session

sqlplus -prelim / as sysdba

-- the hanganalyze information is also available online in V$WAIT_CHAINS

V$WAIT_CHAINS