oracle hang oradebug
session1
SQL> select pid,program from v$process;
PID PROGRAM
---------- ------------------
1 PSEUDO
2 oracle@test1 (PMON)
3 oracle@test1 (PSP0)
4 oracle@test1 (MMAN)
5 oracle@test1 (DBW0)
6 oracle@test1 (LGWR)
7 oracle@test1 (CKPT)
8 oracle@test1 (SMON)
9 oracle@test1 (RECO)
10 oracle@test1 (CJQ0)
11 oracle@test1 (MMON)
12 oracle@test1 (MMNL)
13 oracle@test1 (D000)
14 oracle@test1 (S000)
15 oracle@test1 (TNS V1-V3)
16 oracle@test1
17 oracle@test1
18 oracle@test1 (QMNC)
19 oracle@test1 (q001)
20 oracle@test1 (TNS V1-V3)
21 oracle@test1 (TNS V1-V3)
23 oracle@test1 (q000)
22 rows selected.
SQL> select to_number(addr,'xxxxxxxxxxxxxxxx') from v$latch_parent where name='process allocation';
TO_NUMBER(ADDR,'XXXXXXXXXXXXXXXX')
----------------------------------
1610642928
SQL> oradebug setorapid 2;
Unix process pid: 2983, image: oracle@test1 (PMON)
SQL> oradebug suspend;
Statement processed.
SQL> oradebug call kslgetl 1610642928 1
Function returned 1
此时系统应该hang了
session2
[oracle@test1 bdump]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 20 10:47:37 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01012: not logged on
SQL> exit
session 3
[oracle@test1 bdump]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 20 10:47:37 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug hanganalyze 3
Hang Analysis in /u01/app/oracle/admin/db1/udump/db1_ora_11696.trc
SQL> oradebug hanganalyze 3
Hang Analysis in /u01/app/oracle/admin/db1/udump/db1_ora_11696.trc
session 4
[oracle@test1 bdump]$ sqlplus -prelim / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 20 10:48:32 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug dump systemstate 266
Statement processed.
SQL> oradebug dump systemstate 266
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/admin/db1/udump/db1_ora_11807.trc
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26179376/viewspace-2103649/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
