11g Dba_Scheduler_Running_Jobs

显示全部楼层 · 2015-7-16 14:18:24

数据库中有一堆的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_1461148682REGULAR 3777 +018 22:16:52.02
SYS
AQ$_PLSQL_NTFN_1461148678REGULAR 3402 +018 22:16:52.10
SYS
AQ$_PLSQL_NTFN_1458713792REGULAR 3026 +018 22:16:52.16
SYS
AQ$_PLSQL_NTFN_1458713769REGULAR 2649 +018 22:16:52.22
SYS
AQ$_PLSQL_NTFN_1461148516REGULAR 2270 +018 22:16:52.30
SYS
AQ$_PLSQL_NTFN_1461148511REGULAR 1893 +018 22:16:52.30
SYS
AQ$_PLSQL_NTFN_1461148500REGULAR 1517 +018 22:16:52.32
SYS
AQ$_PLSQL_NTFN_1461148508REGULAR 1141 +018 22:16:52.33
SYS
AQ$_PLSQL_NTFN_1461148497REGULAR
763 +018 22:16:52.33
SYS
AQ$_PLSQL_NTFN_1461148493REGULAR
385 +018 22:16:52.35
SYS
AQ$_PLSQL_NTFN_1461148504REGULAR
8 +018 22:16:52.35
SYS
AQ$_PLSQL_NTFN_1461148489REGULAR 4154 +018 22:16:52.36
SYS
AQ$_PLSQL_NTFN_1458713611REGULAR 3776 +018 22:16:52.38
SYS
AQ$_PLSQL_NTFN_1461148519REGULAR 3400 +018 22:16:52.38
SYS
AQ$_PLSQL_NTFN_1461148471REGULAR 3024 +018 22:16:52.46
SYS
AQ$_PLSQL_NTFN_1461148468REGULAR 2647 +018 22:16:52.46
SYS
AQ$_PLSQL_NTFN_1461148486REGULAR 2268 +018 22:16:52.47
SYS
AQ$_PLSQL_NTFN_1461148483REGULAR 1139 +018 22:16:52.49
SYS
AQ$_PLSQL_NTFN_1461148478REGULAR
761 +018 22:16:52.49
SYS
AQ$_PLSQL_NTFN_1461148685REGULAR 2266 +018 22:16:50.21
OWNER
JOB_NAME
JOB_STYLE SESSION_ID ELAPSED_TIME
------------------------------ ------------------------------ ----------- ---------- -------------------------------------------------------------------------------
QC_SCHEDULER
JOB_QC_BY_INBOUND_ISSUE_RS_QFREGULAR
+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_MINREGULAR 1555 +000 00:00:00.44

千问 · 2015-7-16 14:18:24

我查到的是，这个job和 DBMS_AQADM_SYS.REGISTER_DRIVER 有关

千问 · 2015-7-16 14:18:24

zergduan 发表于 2016-5-9 17:16
我查到的是，这个job和 DBMS_AQADM_SYS.REGISTER_DRIVER 有关
怎样能禁用掉这玩意
我kill掉进程或者停止掉job，又出来新的job（job_name不一样），新的job也是在执行DBMS_AQADM_SYS.REGISTER_DRIVER。

千问 · 2015-7-16 14:18:24

其中一个job的创建sql
begin
sys.dbms_scheduler.create_job(job_name
=> 'SYS.AQ$_PLSQL_NTFN_1463739094',

job_type
=> 'STORED_PROCEDURE',

job_action
=> 'DBMS_AQADM_SYS.REGISTER_DRIVER',

start_date
=> to_date(null),

repeat_interval => '',

end_date
=> to_date(null),

job_class => 'DEFAULT_JOB_CLASS',

enabled
=> true,

auto_drop => true,

comments
=> '');
end;
/