oracle dba_scheduler,11g Dba_Scheduler_Running_Jobs
数据库中有一堆的 AQ$_PLSQL_NTFN_xxx在跑，是做啥的，可以禁掉吗？
SQL> select OWNER,JOB_NAME,JOB_STYLE,SESSION_ID,ELAPSED_TIME from Dba_Scheduler_Running_Jobs;
OWNER JOB_NAME JOB_STYLE SESSION_ID ELAPSED_TIME
-——————————————- ——————————————— —————- ————— ———————————————————————————————————————-
SYS AQ$_PLSQL_NTFN_1461148682 REGULAR 3777 +018 22:16:52.02
SYS AQ$_PLSQL_NTFN_1461148678 REGULAR 3402 +018 22:16:52.10
SYS AQ$_PLSQL_NTFN_1458713792 REGULAR 3026 +018 22:16:52.16
SYS AQ$_PLSQL_NTFN_1458713769 REGULAR 2649 +018 22:16:52.22
SYS AQ$_PLSQL_NTFN_1461148516 REGULAR 2270 +018 22:16:52.30
SYS AQ$_PLSQL_NTFN_1461148511 REGULAR 1893 +018 22:16:52.30
SYS AQ$_PLSQL_NTFN_1461148500 REGULAR 1517 +018 22:16:52.32
SYS AQ$_PLSQL_NTFN_1461148508 REGULAR 1141 +018 22:16:52.33
SYS AQ$_PLSQL_NTFN_1461148497 REGULAR 763 +018 22:16:52.33
SYS AQ$_PLSQL_NTFN_1461148493 REGULAR 385 +018 22:16:52.35
SYS AQ$_PLSQL_NTFN_1461148504 REGULAR 8 +018 22:16:52.35
SYS AQ$_PLSQL_NTFN_1461148489 REGULAR 4154 +018 22:16:52.36
SYS AQ$_PLSQL_NTFN_1458713611 REGULAR 3776 +018 22:16:52.38
SYS AQ$_PLSQL_NTFN_1461148519 REGULAR 3400 +018 22:16:52.38
SYS AQ$_PLSQL_NTFN_1461148471 REGULAR 3024 +018 22:16:52.46
SYS AQ$_PLSQL_NTFN_1461148468 REGULAR 2647 +018 22:16:52.46
SYS AQ$_PLSQL_NTFN_1461148486 REGULAR 2268 +018 22:16:52.47
SYS AQ$_PLSQL_NTFN_1461148483 REGULAR 1139 +018 22:16:52.49
SYS AQ$_PLSQL_NTFN_1461148478 REGULAR 761 +018 22:16:52.49
SYS AQ$_PLSQL_NTFN_1461148685 REGULAR 2266 +018 22:16:50.21
OWNER JOB_NAME JOB_STYLE SESSION_ID ELAPSED_TIME
-——————————————- ——————————————— —————- ————— ———————————————————————————————————————-
QC_SCHEDULER JOB_QC_BY_INBOUND_ISSUE_RS_QF REGULAR +000 00:13:19.36
QC_SCHEDULER JOB_DM_RISK_SCORE REGULAR +000 00:01:29.41
QC_SCHEDULER JOB_DM_RISK_SCORE REGULAR 2314 +000 00:00:48.39
QC_SCHEDULER JOB_QC_REFRE_QUE_STAT_5_MIN REGULAR 1555 +000 00:00:00.44
水深无声
忘是亡心i
分手后的思念是犯贱
还没有评论，来说两句吧...