DB

日常运维的查询 - FND

Alert - 查询预警邮件的日志

SELECT extractvalue(xmltype(O."SYS_NC00040$"), '//SUBJECT') subject
       ,to_char(enq_time, 'YYYY/MM/DD HH24:MI:SS') end_time
       ,row_number() over(ORDER BY enq_time DESC) rn
  FROM apps.wf_notification_out o
 WHERE o.corrid LIKE 'APPS:ALR%';

Concurent

请求名称对应的可执行文件

SELECT e.execution_file_name 
FROM fnd_concurrent_programs p 
,fnd_executables e 
WHERE p.executable_id = e.executable_id 
AND p.concurrent_program_id IN 
(SELECT t.concurrent_program_id 
FROM fnd_concurrent_programs_tl t 
WHERE t.user_concurrent_program_name = '请求名称');

请求运行时正在执行的SQL

SELECT s.* 
FROM fnd_concurrent_requests r, v$session v, v$sql s 
WHERE r.oracle_session_id = v.audsid 
AND v.sql_id = s.sql_id 
AND r.request_id = 543339;

Apex restful

// 查询
select * from apex_rest_resource_modules WHERE workspace LIKE '%MQ%'; 
// apex url
select * from apex_rest_resource_handlers WHERE workspace LIKE '%MQ%'; 
select * from apex_rest_resource_parameters WHERE workspace LIKE '%MQ%'; 
select * from apex_rest_resource_templates WHERE workspace LIKE '%MQ%';
// 清空apex的workspace
BEGIN 
  apex_instance_admin.remove_workspace('MQBONUS'); 
END;
分享到