Oracle 必要的后台进程, 区分哪些进程不能kill

Oracle 必要的后台进程

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.
    
    

Author: halberd

Created: 2020-05-17 Sun 10:42

Validate

posted @ 2020-05-17 10:43  halberd.lee  阅读(2362)  评论(0编辑  收藏  举报