Oracle 必要的后台进程
Table of Contents
1 简述
oralce 每次大的版本变更，后台进程都会有一些变动 ，而有些新增的进程，或者由原来拆分的进程是不能杀的。 杀掉可能会引起数据库crash。哪些进程不能杀一定要清晰、明确。
2 必要进程
2.1 默认启动后台进程
-
11G
[oracle@test1 ~]$ sqlplus -v SQL*Plus: Release 11.2.0.4.0 Production [oracle@test1 ~]$ ps -ef|grep ora|grep -v su|grep -v grep|grep -v bash|grep -v more|grep -v ps oracle 23144 1 0 22:16 ? 00:00:00 ora_pmon_wtdb oracle 23152 1 2 22:16 ? 00:00:12 ora_vktm_wtdb oracle 23156 1 0 22:16 ? 00:00:00 ora_gen0_wtdb oracle 23158 1 0 22:16 ? 00:00:00 ora_diag_wtdb oracle 23160 1 0 22:16 ? 00:00:00 ora_dbrm_wtdb oracle 23165 1 0 22:16 ? 00:00:00 ora_dia0_wtdb oracle 23167 1 0 22:16 ? 00:00:00 ora_mman_wtdb oracle 23169 1 0 22:16 ? 00:00:00 ora_dbw0_wtdb oracle 23171 1 0 22:16 ? 00:00:00 ora_lgwr_wtdb oracle 23173 1 0 22:16 ? 00:00:00 ora_ckpt_wtdb oracle 23175 1 0 22:16 ? 00:00:00 ora_smon_wtdb oracle 23177 1 0 22:16 ? 00:00:00 ora_reco_wtdb oracle 23179 1 0 22:16 ? 00:00:00 ora_mmon_wtdb oracle 23181 1 0 22:16 ? 00:00:00 ora_mmnl_wtdb oracle 23183 1 0 22:16 ? 00:00:00 ora_d000_wtdb oracle 23185 1 0 22:16 ? 00:00:00 ora_s000_wtdb oracle 23237 1 0 22:16 ? 00:00:00 ora_arc0_wtdb oracle 23242 1 0 22:16 ? 00:00:00 ora_arc1_wtdb oracle 23244 1 0 22:16 ? 00:00:00 ora_arc2_wtdb oracle 23246 1 0 22:16 ? 00:00:00 ora_arc3_wtdb oracle 23249 1 0 22:16 ? 00:00:00 ora_qmnc_wtdb oracle 23266 1 0 22:16 ? 00:00:00 ora_cjq0_wtdb oracle 23317 1 0 22:16 ? 00:00:00 ora_q000_wtdb oracle 23319 1 0 22:16 ? 00:00:00 ora_q001_wtdb oracle 24533 1 0 22:21 ? 00:00:00 ora_smco_wtdb oracle 24546 1 0 22:21 ? 00:00:00 ora_w000_wtdb oracle 25095 1 0 22:23 ? 00:00:00 ora_j000_wtdb oracle 25097 1 0 22:23 ? 00:00:00 ora_j001_wtdb
默认启动的后台进程有： pmon vktm GENn diag dbrm DIAn mman DBWn lgwr ckpt smon reco mmon mmnl Dnnn Snnn ARCn qmnc CJQn Qnnn smco Wnnn Jnnn 23 种。 这些进程的作用，运行机制、触发机制，后面再详细了解，先来看下，哪些进程是必须的。
-
12C
12C 以后，由于架构的改变，后台进程也增加了很多。
grep -v grep|grep 'ora_'
在我刚装好的12C RAC (nocdb)里，默认启动了140个进程。当然有一些进程是有重复性的。比如 ora_oNNN_<inst_id> 有4个进程，而 ora_pNNN_<inst_id> 有64个进程。
[oracle@bossdb1 ~]$ ps -ef|grep 'ora_'|grep -v grep|sort -k8n oracle 100001 1 0 May16 ? 00:00:05 ora_p00w_boss1 oracle 100003 1 0 May16 ? 00:00:05 ora_p00x_boss1 oracle 100005 1 0 May16 ? 00:00:05 ora_p00y_boss1 oracle 100007 1 0 May16 ? 00:00:05 ora_p00z_boss1 oracle 100011 1 0 May16 ? 00:00:05 ora_p010_boss1 oracle 100013 1 0 May16 ? 00:00:05 ora_p011_boss1 oracle 100015 1 0 May16 ? 00:00:05 ora_p012_boss1 oracle 100017 1 0 May16 ? 00:00:05 ora_p013_boss1 oracle 100021 1 0 May16 ? 00:00:05 ora_p014_boss1 oracle 100025 1 0 May16 ? 00:00:05 ora_p015_boss1 oracle 100088 1 0 May16 ? 00:00:05 ora_p016_boss1 oracle 100134 1 0 May16 ? 00:00:05 ora_p017_boss1 oracle 100180 1 0 May16 ? 00:00:05 ora_p018_boss1 oracle 100222 1 0 May16 ? 00:00:05 ora_p019_boss1 oracle 100241 1 0 May16 ? 00:00:05 ora_p01a_boss1 oracle 100245 1 0 May16 ? 00:00:05 ora_p01b_boss1 oracle 100249 1 0 May16 ? 00:00:05 ora_p01c_boss1 oracle 100253 1 0 May16 ? 00:00:05 ora_p01d_boss1 oracle 100255 1 0 May16 ? 00:00:05 ora_p01e_boss1 oracle 100257 1 0 May16 ? 00:00:05 ora_p01f_boss1 oracle 100264 1 0 May16 ? 00:00:05 ora_p01g_boss1 oracle 100266 1 0 May16 ? 00:00:04 ora_p01h_boss1 oracle 100268 1 0 May16 ? 00:00:05 ora_p01i_boss1 oracle 100271 1 0 May16 ? 00:00:05 ora_p01j_boss1 oracle 100277 1 0 May16 ? 00:00:05 ora_p01k_boss1 oracle 100281 1 0 May16 ? 00:00:05 ora_p01l_boss1 oracle 100283 1 0 May16 ? 00:00:05 ora_p01m_boss1 oracle 100293 1 0 May16 ? 00:00:05 ora_p01n_boss1 oracle 100340 1 0 May16 ? 00:00:05 ora_p01o_boss1 oracle 100397 1 0 May16 ? 00:00:05 ora_p01p_boss1 oracle 100479 1 0 May16 ? 00:00:05 ora_p01q_boss1 oracle 100496 1 0 May16 ? 00:00:05 ora_p01r_boss1 oracle 100519 1 0 May16 ? 00:00:01 ora_qm02_boss1 oracle 100522 1 0 May16 ? 00:00:43 ora_qm05_boss1 oracle 100525 1 0 May16 ? 00:00:02 ora_q002_boss1 oracle 111359 1 0 May16 ? 00:00:01 ora_q003_boss1 oracle 111369 1 0 May16 ? 00:01:35 ora_o002_boss1 oracle 111371 1 0 May16 ? 00:01:36 ora_o003_boss1 oracle 111379 1 0 May16 ? 00:01:36 ora_o005_boss1 oracle 47748 1 0 09:45 ? 00:00:00 ora_w002_boss1 oracle 51284 1 0 09:55 ? 00:00:00 ora_w000_boss1 oracle 54512 1 0 10:04 ? 00:00:00 ora_w00b_boss1 oracle 58581 1 0 10:16 ? 00:00:00 ora_w005_boss1 oracle 59894 1 0 10:19 ? 00:00:00 ora_w00a_boss1 oracle 60113 1 0 10:19 ? 00:00:00 ora_w003_boss1 oracle 65878 1 0 10:34 ? 00:00:00 ora_ppa7_boss1 oracle 99627 1 0 May16 ? 00:00:08 ora_pmon_boss1 oracle 99629 1 0 May16 ? 00:00:02 ora_clmn_boss1 oracle 99631 1 0 May16 ? 00:00:18 ora_psp0_boss1 oracle 99634 1 0 May16 ? 00:00:13 ora_ipc0_boss1 oracle 99636 1 2 May16 ? 00:21:15 ora_vktm_boss1 oracle 99640 1 0 May16 ? 00:00:08 ora_gen0_boss1 oracle 99642 1 0 May16 ? 00:00:10 ora_mman_boss1 oracle 99646 1 0 May16 ? 00:00:44 ora_gen1_boss1 oracle 99650 1 0 May16 ? 00:00:55 ora_diag_boss1 oracle 99652 1 0 May16 ? 00:00:02 ora_ofsd_boss1 oracle 99656 1 0 May16 ? 00:01:10 ora_dbrm_boss1 oracle 99658 1 0 May16 ? 00:01:09 ora_vkrm_boss1 oracle 99660 1 0 May16 ? 00:00:04 ora_ping_boss1 oracle 99662 1 0 May16 ? 00:00:07 ora_svcb_boss1 oracle 99664 1 0 May16 ? 00:00:02 ora_acms_boss1 oracle 99666 1 0 May16 ? 00:00:10 ora_pman_boss1 oracle 99668 1 0 May16 ? 00:05:43 ora_dia0_boss1 oracle 99670 1 0 May16 ? 00:01:52 ora_lmon_boss1 oracle 99672 1 0 May16 ? 00:01:58 ora_lmd0_boss1 oracle 99674 1 0 May16 ? 00:02:32 ora_lms0_boss1 oracle 99676 1 0 May16 ? 00:02:32 ora_lms1_boss1 oracle 99682 1 0 May16 ? 00:01:46 ora_lmd1_boss1 oracle 99684 1 0 May16 ? 00:00:18 ora_rms0_boss1 oracle 99686 1 0 May16 ? 00:02:33 ora_lmhb_boss1 oracle 99688 1 0 May16 ? 00:00:49 ora_lck1_boss1 oracle 99690 1 0 May16 ? 00:00:09 ora_dbw0_boss1 oracle 99692 1 0 May16 ? 00:00:08 ora_dbw1_boss1 oracle 99694 1 0 May16 ? 00:00:13 ora_lgwr_boss1 oracle 99696 1 0 May16 ? 00:00:34 ora_ckpt_boss1 oracle 99698 1 0 May16 ? 00:00:04 ora_lg00_boss1 oracle 99700 1 0 May16 ? 00:00:03 ora_smon_boss1 oracle 99703 1 0 May16 ? 00:00:02 ora_lg01_boss1 oracle 99705 1 0 May16 ? 00:00:06 ora_smco_boss1 oracle 99707 1 0 May16 ? 00:00:01 ora_reco_boss1 oracle 99711 1 0 May16 ? 00:00:05 ora_lreg_boss1 oracle 99716 1 0 May16 ? 00:00:02 ora_pxmn_boss1 oracle 99718 1 0 May16 ? 00:00:03 ora_rbal_boss1 oracle 99721 1 0 May16 ? 00:00:06 ora_asmb_boss1 oracle 99723 1 0 May16 ? 00:00:59 ora_fenc_boss1 oracle 99731 1 0 May16 ? 00:01:45 ora_mmon_boss1 oracle 99733 1 0 May16 ? 00:01:14 ora_mmnl_boss1 oracle 99735 1 0 May16 ? 00:00:01 ora_d000_boss1 oracle 99737 1 0 May16 ? 00:00:01 ora_s000_boss1 oracle 99739 1 0 May16 ? 00:05:01 ora_cr00_boss1 oracle 99741 1 0 May16 ? 00:00:18 ora_rmv0_boss1 oracle 99744 1 0 May16 ? 00:02:20 ora_gcr0_boss1 oracle 99746 1 0 May16 ? 00:05:01 ora_cr00_boss1 oracle 99748 1 0 May16 ? 00:00:18 ora_rmv1_boss1 oracle 99751 1 0 May16 ? 00:01:43 ora_imr0_boss1 oracle 99753 1 0 May16 ? 00:00:39 ora_scm0_boss1 oracle 99756 1 0 May16 ? 00:00:24 ora_lck0_boss1 oracle 99760 1 0 May16 ? 00:00:05 ora_mark_boss1 oracle 99762 1 0 May16 ? 00:00:03 ora_rsmn_boss1 oracle 99764 1 0 May16 ? 00:00:01 ora_tmon_boss1 oracle 99812 1 0 May16 ? 00:01:39 ora_o000_boss1 oracle 99854 1 0 May16 ? 00:00:02 ora_tt00_boss1 oracle 99856 1 0 May16 ? 00:00:01 ora_tt01_boss1 oracle 99858 1 0 May16 ? 00:00:03 ora_tt02_boss1 oracle 99886 1 0 May16 ? 00:00:02 ora_gtx0_boss1 oracle 99888 1 0 May16 ? 00:00:05 ora_rcbg_boss1 oracle 99894 1 0 May16 ? 00:00:01 ora_aqpc_boss1 oracle 99899 1 0 May16 ? 00:00:05 ora_p000_boss1 oracle 99901 1 0 May16 ? 00:01:03 ora_cjq0_boss1 oracle 99903 1 0 May16 ? 00:00:05 ora_p001_boss1 oracle 99905 1 0 May16 ? 00:00:05 ora_p002_boss1 oracle 99908 1 0 May16 ? 00:00:05 ora_p003_boss1 oracle 99912 1 0 May16 ? 00:00:05 ora_p004_boss1 oracle 99914 1 0 May16 ? 00:00:05 ora_p005_boss1 oracle 99928 1 0 May16 ? 00:00:05 ora_p006_boss1 oracle 99930 1 0 May16 ? 00:00:05 ora_p007_boss1 oracle 99933 1 0 May16 ? 00:00:05 ora_p008_boss1 oracle 99935 1 0 May16 ? 00:00:05 ora_p009_boss1 oracle 99937 1 0 May16 ? 00:00:05 ora_p00a_boss1 oracle 99939 1 0 May16 ? 00:00:05 ora_p00b_boss1 oracle 99941 1 0 May16 ? 00:00:05 ora_p00c_boss1 oracle 99946 1 0 May16 ? 00:00:05 ora_p00d_boss1 oracle 99948 1 0 May16 ? 00:00:05 ora_p00e_boss1 oracle 99950 1 0 May16 ? 00:00:05 ora_p00f_boss1 oracle 99955 1 0 May16 ? 00:00:05 ora_p00g_boss1 oracle 99957 1 0 May16 ? 00:00:05 ora_p00h_boss1 oracle 99962 1 0 May16 ? 00:00:05 ora_p00i_boss1 oracle 99966 1 0 May16 ? 00:00:05 ora_p00j_boss1 oracle 99968 1 0 May16 ? 00:00:05 ora_p00k_boss1 oracle 99970 1 0 May16 ? 00:00:05 ora_p00l_boss1 oracle 99972 1 0 May16 ? 00:00:05 ora_p00m_boss1 oracle 99974 1 0 May16 ? 00:00:05 ora_p00n_boss1 oracle 99976 1 0 May16 ? 00:00:05 ora_p00o_boss1 oracle 99978 1 0 May16 ? 00:00:05 ora_p00p_boss1 oracle 99981 1 0 May16 ? 00:00:05 ora_p00q_boss1 oracle 99989 1 0 May16 ? 00:00:05 ora_p00r_boss1 oracle 99991 1 0 May16 ? 00:00:05 ora_p00s_boss1 oracle 99993 1 0 May16 ? 00:00:05 ora_p00t_boss1 oracle 99996 1 0 May16 ? 00:00:05 ora_p00u_boss1 oracle 99998 1 0 May16 ? 00:00:05 ora_p00v_boss1
2.2 哪些进程不能杀
2.2.1 11G
-
测试脚本
#!/bin/sh function startup() { sqlplus / as sysdba<<EOF startup exit EOF } started=`ps -ef|grep pmon|grep -v grep|awk '{print $2}'` test -z "$started" && startup>>/dev/null sleep 5 prolist=`ps -ef|grep ora|egrep -v 'bash|s[uh]|ps|grep|more|sleep|awk|LOCAL|sysdba|log' |awk '{print $NF}'` #echo $prolist for i in $prolist do proc_key=`echo $i|awk -F _ '{print $2}'` pid=`ps -ef|grep $proc_key|grep -v grep|awk '{print $2}'` #echo "oracle 进程 $i 进程关键字 $proc_key 进程ID $pid" #echo "kill 进程 $proc_key" test -z $pid && echo "$proc_key 不存在"|| kill -9 "$pid" sleep 20 pc=`ps -ef|grep pmon|grep -v grep|wc -l` echo "PMON 进程个数 $pc" if [ $pc -eq 0 ]; then echo "Kill 进程 $proc_key 会导致实例crash!" startup >> /dev/null sleep 5 else echo "Kill 进程 $proc_key 不会导致实例crash!" wexists=`ps -ef|grep w000|grep -v grep|wc -l` smc0exists=`ps -ef|grep smc|grep -v grep|wc -l` test -z $wexists && echo "w000 进程不存在" test -z $smc0exists && echo "smc 进程不存在" fi done
-
结果
Kill 进程 pmon 会导致实例crash! Kill 进程 vktm 会导致实例crash! Kill 进程 gen0 会导致实例crash! Kill 进程 diag 不会导致实例crash! Kill 进程 dbrm 会导致实例crash! Kill 进程 dia0 不会导致实例crash! Kill 进程 mman 会导致实例crash! Kill 进程 dbw0 会导致实例crash! Kill 进程 lgwr 会导致实例crash! Kill 进程 ckpt 会导致实例crash! Kill 进程 smon 会导致实例crash! Kill 进程 reco 不会导致实例crash! Kill 进程 mmon 不会导致实例crash! Kill 进程 mmnl 不会导致实例crash! Kill 进程 d000 不会导致实例crash! Kill 进程 s000 不会导致实例crash! Kill 进程 p000 不会导致实例crash! Kill 进程 p001 不会导致实例crash! Kill 进程 arc0 不会导致实例crash! Kill 进程 arc1 不会导致实例crash! Kill 进程 arc2 不会导致实例crash! Kill 进程 arc3 不会导致实例crash! Kill 进程 qmnc 不会导致实例crash! Kill 进程 cjq0 不会导致实例crash! Kill 进程 q000 不会导致实例crash! Kill 进程 q001 不会导致实例crash!
秒做整理，可知Oracle 11G中 pmon,vktm,gen0,dbrm,mman,dbw0,lgwr,ckpt,smon 这 9 个进程是不能 杀的。都会导致数据库宕机。
上面的脚本，在测试过程中，sleep 的时间调整短一些，发现有时候kill dia0 进程，也会引起实例宕机。 所以这是一个陷阱，不小心就有可能掉进去。
2.2.2 12C
12C 及以后的版本中，对于进程被杀掉是否会引起实例重启，可以查询基表:x$ksupr 如下：
-
杀掉会引起实例宕机
SELECT indx,ksuprpnm,TO_CHAR(ksuprflg,'XXXXXXXXXXXXXXXX'),KSUPROSID FROM x$ksupr WHERE BITAND(ksuprflg,4) = 4 ORDER BY indx; INDX KSUPRPNM TO_CHAR(KSUPRFLG, KSUPROSID ---------- ---------------------------- ----------------- ------------------------ 2 oracle@bossdb1 (PMON) E 99627 3 oracle@bossdb1 (CLMN) E 99629 4 oracle@bossdb1 (PSP0) 6 99631 5 oracle@bossdb1 (IPC0) 6 99634 6 oracle@bossdb1 (VKTM) 6 99636 7 oracle@bossdb1 (GEN0) 6 99640 8 oracle@bossdb1 (MMAN) 6 99642 13 oracle@bossdb1 (OFSD) 6 99652_99654 15 oracle@bossdb1 (DBRM) 6 99656 19 oracle@bossdb1 (ACMS) 6 99664 20 oracle@bossdb1 (PMAN) 6 99666 22 oracle@bossdb1 (LMON) 6 99670 23 oracle@bossdb1 (LMD0) 6 99672 24 oracle@bossdb1 (LMS0) 6 99674 25 oracle@bossdb1 (LMS1) 6 99676 26 oracle@bossdb1 (LMD1) 6 99682 27 oracle@bossdb1 (RMS0) 6 99684 29 oracle@bossdb1 (LCK1) 6 99688 30 oracle@bossdb1 (DBW0) 6 99690 31 oracle@bossdb1 (DBW1) 6 99692 32 oracle@bossdb1 (LGWR) 6 99694 33 oracle@bossdb1 (CKPT) 6 99696 34 oracle@bossdb1 (LG00) 6 99698 35 oracle@bossdb1 (SMON) 16 99700 36 oracle@bossdb1 (LG01) 6 99703 40 oracle@bossdb1 (LREG) 6 99711 43 oracle@bossdb1 (RBAL) 6 99718 44 oracle@bossdb1 (ASMB) 6 99721 45 oracle@bossdb1 (FENC) 6 99723 50 oracle@bossdb1 (CR00) 6 99739 51 oracle@bossdb1 (RMV0) 6 99741 53 oracle@bossdb1 (CR00) 6 99746 54 oracle@bossdb1 (RMV1) 6 99748 55 oracle@bossdb1 (IMR0) 6 99751 57 oracle@bossdb1 (LCK0) 6 99756 70 oracle@bossdb1 (GTX0) 6 99886 36 rows selected. -
杀掉不会引起实例重启
SELECT indx,ksuprpnm,TO_CHAR(ksuprflg,'XXXXXXXXXXXXXXXX'),KSUPROSID FROM x$ksupr WHERE BITAND(ksuprflg,4) != 4 and KSUPROSID is not null ORDER BY indx / INDX KSUPRPNM TO_CHAR(KSUPRFLG, KSUPROSID ---------- ---------------------------- ----------------- ------------------------ 0 oracle@bossdb1 (M000) 0 67933 9 oracle@bossdb1 (W000) 2 51284 10 oracle@bossdb1 (GEN1) 2 99646_99648 11 oracle@bossdb1 (SCMN) 2 99646_99646 12 oracle@bossdb1 (DIAG) 2 99650 14 oracle@bossdb1 (SCMN) 2 99652_99652 16 oracle@bossdb1 (VKRM) 2 99658 17 oracle@bossdb1 (PING) 2 99660 18 oracle@bossdb1 (SVCB) 2 99662 21 oracle@bossdb1 (DIA0) 2 99668 28 oracle@bossdb1 (LMHB) 2 99686 37 oracle@bossdb1 (SMCO) 2 99705 38 oracle@bossdb1 (RECO) 2 99707 39 oracle@bossdb1 (Q003) 2 111359 41 oracle@bossdb1 (TNS V1-V3) 0 67767 42 oracle@bossdb1 (PXMN) 2 99716 46 oracle@bossdb1 (MMON) 2 99731 47 oracle@bossdb1 (MMNL) 2 99733 48 oracle@bossdb1 (D000) 80 99735 49 oracle@bossdb1 (S000) 40 99737 52 oracle@bossdb1 (GCR0) 2 99744 56 oracle@bossdb1 (SCM0) 2 99753 58 oracle@bossdb1 (MARK) 2 99760 59 oracle@bossdb1 (RSMN) 2 99762 60 oracle@bossdb1 (TMON) 2 99764 61 oracle@bossdb1 (W002) 2 47748 62 oracle@bossdb1 (O000) 2 99812 63 oracle@bossdb1 (P002) 0 99905 64 oracle@bossdb1 (TNS V1-V3) 0 50565 65 oracle@bossdb1 (PPA7) 0 65878 66 oracle@bossdb1 (TT00) 2 99854 67 oracle@bossdb1 (TT01) 2 99856 68 oracle@bossdb1 (TT02) 2 99858 69 oracle@bossdb1 (O002) 2 111369 71 oracle@bossdb1 (RCBG) 2 99888 72 oracle@bossdb1 (AQPC) 2 99894 73 oracle@bossdb1 (W005) 2 58581 74 oracle@bossdb1 (QM02) 2 100519 75 oracle@bossdb1 (P000) 0 99899 76 oracle@bossdb1 (CJQ0) 2 99901 77 oracle@bossdb1 (P001) 0 99903 78 oracle@bossdb1 (P003) 0 99908 79 oracle@bossdb1 (M000) 0 67933 80 oracle@bossdb1 (P004) 0 99912 81 oracle@bossdb1 (P005) 0 99914 82 oracle@bossdb1 (TNS V1-V3) 0 99921 83 oracle@bossdb1 (TNS V1-V3) 0 99924 84 oracle@bossdb1 (P006) 0 99928 85 oracle@bossdb1 (TNS V1-V3) 0 99926 86 oracle@bossdb1 (P007) 0 99930 87 oracle@bossdb1 (P008) 0 99933 88 oracle@bossdb1 (P009) 0 99935 89 oracle@bossdb1 (P00A) 0 99937 90 oracle@bossdb1 (P00B) 0 99939 91 oracle@bossdb1 (P00C) 0 99941 92 oracle@bossdb1 (P00D) 0 99946 93 oracle@bossdb1 (P00E) 0 99948 94 oracle@bossdb1 (P00F) 0 99950 95 oracle@bossdb1 (P00G) 0 99955 96 oracle@bossdb1 (W00A) 2 59894 97 oracle@bossdb1 (P00H) 0 99957 98 oracle@bossdb1 (P00I) 0 99962 99 oracle@bossdb1 (P00J) 0 99966 100 oracle@bossdb1 (P00K) 0 99968 101 oracle@bossdb1 (P00L) 0 99970 102 oracle@bossdb1 (P00M) 0 99972 103 oracle@bossdb1 (P00N) 0 99974 104 oracle@bossdb1 (P00O) 0 99976 105 oracle@bossdb1 (P00P) 0 99978 106 oracle@bossdb1 (P00Q) 0 99981 107 oracle@bossdb1 (P00R) 0 99989 108 oracle@bossdb1 (P00S) 0 99991 109 oracle@bossdb1 (P00T) 0 99993 110 oracle@bossdb1 (P00U) 0 99996 111 oracle@bossdb1 (P00V) 0 99998 112 oracle@bossdb1 (P00W) 0 100001 113 oracle@bossdb1 (P00X) 0 100003 114 oracle@bossdb1 (P00Y) 0 100005 115 oracle@bossdb1 (P00Z) 0 100007 116 oracle@bossdb1 (O003) 2 111371 117 oracle@bossdb1 (P010) 0 100011 118 oracle@bossdb1 (P011) 0 100013 119 oracle@bossdb1 (P012) 0 100015 120 oracle@bossdb1 (P013) 0 100017 121 oracle@bossdb1 (P01O) 0 100340 122 oracle@bossdb1 (P014) 0 100021 123 oracle@bossdb1 (W003) 2 60113 124 oracle@bossdb1 (P015) 0 100025 125 oracle@bossdb1 (W00B) 2 54512 126 oracle@bossdb1 (P016) 0 100088 127 oracle@bossdb1 (P01E) 0 100255 128 oracle@bossdb1 (P017) 0 100134 129 oracle@bossdb1 (O005) 2 111379 130 oracle@bossdb1 (P018) 0 100180 131 oracle@bossdb1 (P019) 0 100222 132 oracle@bossdb1 (M001) 0 67923 133 oracle@bossdb1 (P01A) 0 100241 134 oracle@bossdb1 (P01B) 0 100245 135 oracle@bossdb1 (M000) 0 66013 136 oracle@bossdb1 (P01C) 0 100249 137 oracle@bossdb1 (M001) 0 66011 138 oracle@bossdb1 (P01D) 0 100253 139 oracle@bossdb1 (P01F) 0 100257 140 oracle@bossdb1 (P01G) 0 100264 141 oracle@bossdb1 (P01H) 0 100266 142 oracle@bossdb1 (P01I) 0 100268 143 oracle@bossdb1 (P01J) 0 100271 144 oracle@bossdb1 (PPA7) 0 61713 145 oracle@bossdb1 (M000) 0 63592 146 oracle@bossdb1 (P01K) 0 100277 147 oracle@bossdb1 (M001) 0 63589 148 oracle@bossdb1 (P01L) 0 100281 149 oracle@bossdb1 (P01M) 0 100283 150 oracle@bossdb1 (P01N) 0 100293 151 oracle@bossdb1 (P01P) 0 100397 152 oracle@bossdb1 (P01Q) 0 100479 153 oracle@bossdb1 (P01R) 0 100496 154 oracle@bossdb1 (QM05) 2 100522 155 oracle@bossdb1 (Q002) 2 100525 156 oracle@bossdb1 (M001) 0 63295 157 oracle@bossdb1 (M002) 0 41036 158 oracle@bossdb1 (M002) 0 117572 159 oracle@bossdb1 (M003) 0 100578 160 oracle@bossdb1 (Q005) 0 100582 161 oracle@bossdb1 (M003) 0 100550 162 oracle@bossdb1 (M004) 0 100552 163 oracle@bossdb1 (M000) 0 100560 164 oracle@bossdb1 (M006) 0 100558 165 oracle@bossdb1 (M007) 0 100566 166 oracle@bossdb1 (M008) 0 100568 1279 oracle@bossdb1 (TNS V1-V3) 0 99550 131 rows selected.
Created: 2020-05-17 Sun 10:42