SQL> show parameter job_queue_processes;51Testing软件测试网.A:j]l4h4~}?P 51Testing软件测试网1x
ysD;YE8Es NAME TYPE VALUE 2]*o^/y+}Iv`AhO0 job_queue_processes integer 1051Testing软件测试网{ ~'vo2t5y*M
2、查看列队控制是否为零,这个参数不启用,通过会导致任务不能启动。
SQL> show parameter aq_tm_processes;51Testing软件测试网4CA&p_Y&S.o9w NAME TYPE VALUE51Testing软件测试网S"`GW:['@sc i9m ------------------------------------ ----------- ------------------------------ 0b4kJ
NpF\ a${4h S1iX0aq_tm_processes integer 0
EM 预警: 严重: oamis - 1 distinct types of ORA- errors have be...
名称=oamis !@~| Kc-JBN0类型=Database51Testing软件测试网msOi9y 主机=njtrh-q43iwmp9j
HvO.|1Jb0度量=Generic Alert Log Error Status51Testing软件测试网q
dTz3HD$K@9S;h 时间戳=2008-11-3 上午10时36分24秒 CST "`TW&MM%|"b0严重性=严重 3^t#d
ru%]
e0消息=1 distinct types of ORA- errors have been found in the alert log.51Testing软件测试网(z9?B$A e 规则名=Database Availability and Critical States51Testing软件测试网'a-l"R'w1f E p4]| 规则所有者=SYSMAN