EBS:Oracle 数据库执行慢SQL

至少有APPS权限

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

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)