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(+); |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了