查询并发程序是否启动跟踪功能-trc文件对数据库性能有代码,OracleEBS代码库,德仔网

代码语言

代码分类

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

作者:dezai / 发布于2014/1/26/ 1351

查询并发程序是否启动跟踪功能-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;

试试其它关键字

　并发程序是否启动跟踪功能　

同语言下

可能有用的

dezai贡献的其它代码(1065)