查询并发程序是否启动跟踪功能-trc文件对数据库性能有影响
/* Formatted on 2018/3/14 23:38:51 (QP5 v5.256.13226.35538) */
SELECT icon_name
, row_id
, user_concurrent_program_name
, enabled_flag
, concurrent_program_name
, description
, execution_options
, request_priority
, increment_proc
, run_alone_flag
, restart
, enable_trace
, nls_compliant
, output_file_type
, save_output_flag
, print_flag
, minimum_width
, minimum_length
, output_print_style
, required_style
, printer_name
, application_id
, last_update_date
, execution_method_code
, last_update_login
, creation_date
, created_by
, executable_id
, last_updated_by
, executable_application_id
, concurrent_program_id
, concurrent_class_id
, class_application_id
, argument_method_code
, request_set_flag
, queue_method_code
, queue_control_flag
, srs_flag
, cd_parameter
, mls_executable_id
, mls_executable_app_id
, resource_consumer_group
, rollback_segment
, optimizer_mode
, security_group_id
, enable_time_statistics
, refresh_portlet
, program_type
, activity_summarizer
, allow_multiple_pending_request
, delete_log_file
, template_appl_short_name
, template_code
, multi_org_category
FROM fnd_concurrent_programs_vl
WHERE 1 = 1
AND queue_control_flag = 'N' --and (APPLICATION_ID = 555)
-- and (CONCURRENT_PROGRAM_ID = 46914) and ENABLE_TRACE = 'Y'
ORDER BY application_id, user_concurrent_program_name
