what is the oracle diagnostic methodology (odm)? [id 312789.1]
odm test:查询语句：
select to_number(addr,'xxxxxxxxxxxxxxxx') 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 a:
[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, 2011, oracle. all rights reserved.
connected to:
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,'xxxxxxxxxxxxxxxx') from v$latch_parent where;
to_number(addr,'xxxxxxxxxxxxxxxx')
----------------------------------
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.
此时仍可以登录成功
[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, 2011, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.3.0 - production
with the partitioning, olap, data mining and real application testing options
session a:
sql> oradebug call kslgetl 536896888 1;
function returned 1
此时，已经不能使用任何用户登录。
[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, 2011, oracle. all rights reserved.
…
，