ORACLE 的session问题，立刻给分

10     139        37593 AP\######$   6784:10068    ORACLE.EXEoracle的系统进程

解决方案 »

  1.   

    他们的SID的数值都是多少啊？
    最好把屏幕显示贴上来
      

  2.   

    这应该是oracle自己的进程，因为“PROGRAM”是ORACLE.EXE。但它具体完成什么功能我就不知道了，学习中，我记得在网上看到过一个根据sid，srial#取系统进程号的语句，后来不见了
      

  3.   

    我知道那是系统的进程，可是这个进程过一段时间就启动一个线程，在v$session表中增加一条记录，导致v$session表的记录条数暴涨！大家遇到过这个问题吗？帮我分析一下。增加的纪录格式和我上面贴的差不多
      

  4.   

    表的记录：PROGRAM字段好多条都是ORACLE，为什么？正常的话应该只有2-3条
        SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE TERMINAL PROGRAM TYPE SQL_ADDRESS SQL_HASH_VALUE PREV_SQL_ADDR PREV_HASH_VALUE MODULE MODULE_HASH ACTION ACTION_HASH CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIME LAST_CALL_ET PDML_ENABLED FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER RESOURCE_CONSUMER_GROUP PDML_STATUS PDDL_STATUS PQ_STATUS CURRENT_QUEUE_DURATION CLIENT_IDENTIFIER
    57 2B9E1D44 59 72 38227 2B9AE6E4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS kawabyo 2184:2192 AP\KAWABATA-HP KAWABATA-HP visual.exe USER 0 0 2EAAE8D8 3409937413 visual.exe 0 0 MCFrame360KAWABYO116 7612 -1 0 0 0 2006/4/7 9:33 16460 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    58 2B9E26B4 60 715 38253 2B9B3964 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:8680 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2DC67324 951443549 ORACLE.EXE 0 0 7622 28847 6 0 0 2006/4/7 10:18 14494 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    59 2B9E3024 61 87 38223 2B9AD424 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:9684 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D395534 3870749845 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 9:25 3551 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    60 2B9E3994 62 241 38249 2B9AF9A4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:6368 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2F7AC894 1766766162 ORACLE.EXE 0 0 7622 1 6 0 0 2006/4/7 10:13 11389 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    61 2B9E4304 63 98 38203 2B9A9824 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS cosng308 1416:1492 AP\SUZUKI-EP-5-19 SUZUKI-EP-5-19 visual.exe USER 0 0 2D382C24 714075952 visual.exe 0 0 MCFrame360admin  113 7612 -1 0 0 0 2006/4/7 9:00 18562 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    62 2B9E4C74 64 31 38248 2B9B2A64 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:7012 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D22937C 2432622688 ORACLE.EXE 0 0 7622 25149 6 0 0 2006/4/7 10:10 15018 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    63 2B9E55E4 65 76 38199 2B9A8924 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:492 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D3C9F5C 2887562601 ORACLE.EXE 0 0 7622 25370 6 0 0 2006/4/7 8:49 4369 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    64 2B9E5F54 66 94 38193 2B9A7664 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS ???a???????? 2552:2556 SEIWAKK\SEIWA11 SEIWA11 visual.exe USER 0 0 2D3043CC 2911553916 visual.exe 0 0 MCFrame360admin2 113 7609 -1 0 0 0 2006/4/7 8:23 19843 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    65 2B9E68C4 67 233 38289 2B9B7564 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:9136 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D22937C 2432622688 ORACLE.EXE 0 0 7629 25139 6 0 0 2006/4/7 14:00 1232 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    66 2B9E7234 68 34 38217 2B9AC164 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS YHASHINO 2924:2928 AP\HASHINO-HP HASHINO-HP visual.exe USER 0 0 2E9122C4 2325402725 visual.exe 0 0 MCFrame360HASHIYO125 7612 28861 6 0 0 2006/4/7 9:10 18573 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    67 2B9E7BA4 69 88 38190 2B9A6B24 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\yomogch 3120:3116 AP\YOMOGIDA-HP YOMOGIDA-HP visual.exe USER 0 0 2E68F384 992411105 visual.exe 0 0 MCFrame360admin  113 7612 -1 0 0 0 2006/4/7 8:06 16570 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    68 2B9E8514 70 77 38251 2B9B31E4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:8904 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D395534 3870749845 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 10:16 9610 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    69 2B9E8E84 71 45 38269 2B9B4864 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:7812 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D3C9F5C 2887562601 ORACLE.EXE 0 0 7622 25370 6 0 0 2006/4/7 11:55 8776 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    70 2B9E97F4 72 302 38263 2B9B4C24 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\KMURANO 2072:2440 AP\MURANO-HP MURANO-HP visual.exe USER 0 0 2D3043CC 2911553916 visual.exe 0 0 MCFrame360admin  113 7622 -1 0 0 0 2006/4/7 11:24 10514 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    71 2B9EA164 73 79 38260 2B9B44A4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:7356 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D395534 3870749845 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 10:54 11634 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    72 2B9EAAD4 74 15 38264 2B9B4FE4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\KMURANO 2072:2440 AP\MURANO-HP MURANO-HP visual.exe USER 0 0 2D322B24 1580345674 visual.exe 0 0 MCFrame360MURANKO125 7622 -1 0 0 0 2006/4/7 11:24 10618 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    73 2B9EB444 75 61 38265 2B9B53A4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:9512 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D56F3A0 1284925421 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 11:29 10218 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    74 2B9EBDB4 76 13 38266 2B9B5764 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:8056 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D208598 2993021150 ORACLE.EXE 0 0 7622 28842 6 0 0 2006/4/7 11:31 10219 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    75 2B9EC724 77 12 38267 2B9B5B24 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:7320 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D395534 3870749845 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 11:35 8742 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    76 2B9ED094 78 27 38268 2B9B5EE4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:8464 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D22937C 2432622688 ORACLE.EXE 0 0 7622 25148 4 0 0 2006/4/7 11:45 8904 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
    77 2B9EDA04 79 45 38270 2B9B62A4 30 JACCS 0 2147483644 INACTIVE DEDICATED 30 JACCS AP\JACCS2$ 6784:5436 JACCS2 JACCS2 ORACLE.EXE USER 0 0 2D395534 3870749845 ORACLE.EXE 0 0 7622 -1 0 0 0 2006/4/7 12:01 8441 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0
      

  5.   

    select sql_address from v$session where sid=... and serial#= ...
    比如你得到670BF09C
    select * from v$sqltext where sql_address='670BF09C'
    这里就是这个session得运行sql...
      

  6.   

    为什么得到的SQL文都是一段一段的，不时完整的阿