Reproduce the Hang of the Oracle database

WhatistheOracleDiagnosticMethodology (ODM )? [Id310489.1] ODMTEST: query statement: selectto_number (addr,

What is the Oracle Diagnostic Methodology (ODM )? [ID 312789.1] odm test: query statement: select to_number (addr,

What is the Oracle Diagnostic Methodology (ODM )? [ID 312789.1]

Odm test:

Query statement:

Select to_number (addr, 'xxxxxxxxxxxxxxxxxx') from v $ latch_parent where;
Select name from v $ latch_parent where name like '% library % ';
Select name from v $ latch_children where name like '% library % ';
Select name from v $ latch_parent where name like '% process % ';

Session:

[Oracle @ resoft ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 22:52:42 2013

Copyright (c) 1982,201 1, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select to_number (addr, 'xxxxxxxxxxxxxxxxxx') from v $ latch_parent where;

TO_NUMBER (ADDR, 'xxxxxxxxxxxxxxxxxxxx ')
----------------------------------
536896888

SQL> select pid, program from v $ process;

PID PROGRAM
----------------------------------------------------------
1. PSEUDO
2 oracle @ resoft (PMON)
3 oracle @ resoft (PSP0)
4 oracle @ resoft (VKTM)
5 oracle @ resoft (GEN0)
6 oracle @ resoft (DIAG)
7 oracle @ resoft (DBRM)
8 oracle @ resoft (DIA0)
9 oracle @ resoft (MMAN)
10 oracle @ resoft (DBW0)
11 oracle @ resoft (LGWR)

PID PROGRAM
----------------------------------------------------------
12 oracle @ resoft (CKPT)
13 oracle @ resoft (SMON)
14 oracle @ resoft (RECO)
15 oracle @ resoft (MMON)
16 oracle @ resoft (MMNL)
17 oracle @ resoft (D000)
18 oracle @ resoft (S000)
19 oracle @ resoft (TNS V1-V3)
20 oracle @ resoft (QMNC)
21 oracle @ resoft (Q000)
22 oracle @ resoft (Q001)

PID PROGRAM
----------------------------------------------------------
23 oracle @ resoft (SMCO)
24 oracle @ resoft (VKRM)
25 oracle @ resoft (CJQ0)
26 oracle @ resoft (W000)
27 oracle @ resoft (TNS V1-V3)
28 oracle @ resoft (W001)

SQL> oradebug setorapid 2;
Oracle pid: 2, Unix process pid: 2770, image: oracle @ resoft (PMON)

SQL> oradebug suspend;
Statement processed.

At this time, you can still log on successfully.

[Oracle @ resoft ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:01:31 2013

Copyright (c) 1982,201 1, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Session:
SQL> oradebug call kslgetl 536896888 1;
Function returned 1

At this time, you cannot use any user to log on.

[Oracle @ resoft ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:03:37 2013

Copyright (c) 1982,201 1, Oracle. All rights reserved.

...

,