【ASM内部原理】_asm_kill_unresponsive_clients & _asm_healthcheck

本文展示了如何使用SQL查询获取Oracle数据库版本及进程信息，并通过oradebug命令对特定数据库后台进程进行调试，揭示了数据库内部运行机制。

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