【ASM内部原理】_asm_kill_unresponsive_clients & _asm_healthcheck_timeout

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

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569