查询并发程序是否启动跟踪功能-trc文件对数据库性能有

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 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;