FilesExpand file tree

 main

/

db_hang.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

21 lines (15 loc) · 671 Bytes

 main

/

db_hang.sql

Top

File metadata and controls

• Code
• Blame

21 lines (15 loc) · 671 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

-- 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