EBS: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(+);
优质生活从拆开始