EBS:Oracle 資料庫執行慢SQL

samrv發表於2024-06-09
Oracle資料庫SQL

至少有APPS許可權

SELECT a.request_id,floor((sysdate-a.actual_start_date)*24) hou,
       round(((sysdate-a.actual_start_date)*24-
       floor((sysdate-a.actual_start_date)*24))*60) mini,
       c.sql_address, c.inst_id,f.full_name,u.user_name,
       b.user_concurrent_program_name,r.responsibility_key, w.event,
       a.actual_start_date , a.argument_text,b.description,
       b.concurrent_program_name, a.phase_code, a.status_code,
       c.sid, c.serial#, d.pid, d.spid, w.*
FROM fnd_concurrent_requests a, fnd_user u, per_all_people_f f,
       fnd_concurrent_programs_vl b, Gv$session c,
       Gv$process d, Gv$session_wait w,fnd_responsibility r
WHERE a.concurrent_program_id = b.CONCURRENT_PROGRAM_ID
AND a.Oracle_Session_Id = c.audsid
AND c.paddr = d.addr
and c.inst_id=d.inst_id
and w.inst_id=c.inst_id
and c.sid = w.sid
and r.responsibility_id=a.responsibility_id
AND a.phase_code = 'R'
and u.user_id=a.requested_by
and u.employee_id=f.person_id(+);

　　

摘自：Oracle 資料庫執行慢SQL - Jenrry - 部落格園 (cnblogs.com)

相關文章