工作流管理器的检查点(DB层面):
--1:数据库job aq参数设置,建议设置job_queue_processes》=10
select p.NAME,p.DESCRIPTION,p.VALUE from
v$parameter p
where p.name in('job_queue_processes','aq_tm_processes');
--2并发管理器设置检查,设置为yes
SELECT pro.profile_option_name,
pro.user_profile_option_name,
prv.profile_option_value
FROM apps.fnd_profile_options_vl pro,
applsys.fnd_profile_option_values prv
WHERE pro.profile_option_id = prv.profile_option_id(+)
AND prv.level_id = 10001
AND pro.profile_option_name = 'CONC_GSM_ENABLED'
--3并发管理器的service manager target与actual检查 >=1
SELECT fcq.concurrent_queue_name,
fcq.user_concurrent_queue_name,
fcq.target_node,
fcq.max_processes target,
fcq.running_processes actual
FROM fnd_concurrent_queues_vl fcq
WHERE fcq.enabled_flag = 'Y'
AND fcq.concurrent_queue_name LIKE 'FNDSM%'
--4工作流agent listener service 检查
SELECT fcq.concurrent_queue_name,
fcq.user_concurrent_queue_name,
fcq.target_node,
fcq.max_processes target,
fcq.running_processes actual,
fcqs.sleep_seconds
FROM fnd_concurrent_queues_vl fcq, fnd_concurrent_queue_size fcqs
WHERE fcq.concurrent_queue_id = fcqs.concurrent_queue_id
AND fcq.enabled_flag = 'Y'
AND fcq.concurrent_queue_name = 'WFALSNRSVC'