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 ]     WARNING: client [PROD1:PROD] not responsive for 214s; state=0x1. killing pid 17379 WARNING: client [PROD1:PROD] cleanup delayed; waited 274s, pid 17379 mbr 0x1 WARNING: client [PROD1:PROD1] not responsive for 206s; state=0x1. killing pid 7865　 Thu Feb 07 10:13:37 2013 WARNING: client [PROD1:PROD1] cleanup delayed; waited 266s, pid 7865 mbr 0x2 Thu Feb 07 10:14:27 2013 System State dumped to trace file /u01/app/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_ora_28130.trc Thu Feb 07 10:14:37 2013 WARNING: client [PROD1:PROD1] cleanup delayed; waited 326s, pid 7865 mbr 0x2   _asm_kill_unresponsive_clients = TRUE _asm_healthcheck_timeout = 180(s) seconds until health check takes action   "NOTE: parameter _asm_kill_unresponsive_clients is disabled: not ejecting client