SQL> SQL> select * From V$VERSION;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL>select pid,pname from v$process
PID PNAME
---------- -----
1
2 PMON
3 PSP0
4 VKTM
5 GEN0
6 DIAG
7 DBRM
8 PING
9 ACMS
10 DIA0
11 LMON
12 LMD0
13 LMS0
14 RMS0
15 LMHB
16 MMAN
17 DBW0
18 LGWR
19 CKPT
20 SMON
21 RECO
22 RBAL
23 ASMB
24 MMON
25 MMNL
26 MARK
27 SMCO
28 LCK0
29 RSMN
30 J000
31 ARC1
32 J001
33 W000
34 W001
35
36 ARC0
37 ARC2
38 ARC3
39 GTX0
40 RCBG
41 QMNC
42
43 Q000
44 O000
45 CJQ0
51 Q001
53 GCR0
23 ASMB
SQL> oradebug setorapid 23;
Oracle pid: 23, Unix process pid: 5771, image: oracle@maclean1.oracle.com (ASMB)
SQL> oradebug short_stack;
ksedsts()+461<-ksdxfstk()+32<-ksdxcb()+1876<-sspuser()+112<-__sighandler()<-read()+14<-ntpfprd()+115<-nsbasic_brc()+376<-nsbrecv()+69<-nioqrc()+485<-ttcdrv()+1461<-nioqwa()+61<-upirtrc()+1385<-upirtr()+148<-kpurcs()+34<-OCIKDispatch()+42<-kfnOpExecuteWithWait()+722<-kfnbRun()+5370<-ksbrdp()+971<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+244<-_start()+36
SQL>
SQL> oradebug suspend;
Statement processed.
SQL> oradebug short_stack;
ksedsts()+461<-ksdxfstk()+32<-ksdxcb()+1876<-ksdxsus()+1101<-ksdxffrz()+40<-ksdxcb()+1876<-sspuser()+112<-__sighandler()<-read()+14<-ntpfprd()+115<-nsbasic_brc()+376<-nsbrecv()+69<-nioqrc()+485<-ttcdrv()+1461<-nioqwa()+61<-upirtrc()+1385<-upirtr()+148<-kpurcs()+34<-OCIKDispatch()+42<-kfnOpExecuteWithWait()+722<-kfnbRun()+5370<-ksbrdp()+971<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+244<-_start()+36
2013-05-21 09:19:50.952000 -04:00
Unix process pid: 5771, image: oracle@maclean1.oracle.com (ASMB) flash frozen [ command #2 ]
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1278342
