根据等待事件查询后台会话的信息(oem->excel)

最新推荐文章于 2024-09-16 09:47:29 发布

launch_225

最新推荐文章于 2024-09-16 09:47:29 发布

阅读量632

点赞数

文章标签： excel session class application sql module

本文链接：https://blog.csdn.net/launch_225/article/details/7073166

版权

select ash.session_id,
       ash.session_serial#,
       ash.instance,
       ash.program,
       s.machine,
       s.username,
       s.osuser,
       ash.event,
       ash.wait_class,
       sql.sql_text
from (select distinct session_id,
                        session_serial#,
                        SYS_CONTEXT('USERENV', 'INSTANCE_NAME') instance,
                        sql_id,
                        event,
                        wait_class,
                        program,
                        module,
                        action
          from v$active_session_history
         where wait_class = 'Application'
           and to_char(sample_time, 'hh24mi') =
               to_char(sysdate - 1 / 24 / 60, 'hh24mi')) ash,
       v$sqlarea sql,
       v$session s
where ash.sql_id = sql.sql_id
   and ash.session_id = s.sid(+)
union all
select ash.session_id,
       ash.session_serial#,
       ash.instance,
       ash.program,
       s.machine,
       s.username,
       s.osuser,
       ash.event,
       ash.wait_class,
       sql.sql_text
from (select distinct session_id,
                        session_serial#,
                        SYS_CONTEXT('USERENV', 'INSTANCE_NAME') instance,
                        sql_id,
                        event,
                        wait_class,
                        program,
                        module,
                        action
          from v$active_session_history@dblink
         where wait_class = 'Application'
           and to_char(sample_time, 'hh24mi') =
               to_char(sysdate - 1 / 24 / 60, 'hh24mi')) ash,
       v$sqlarea@dblink sql,
       v$session@dblink s
where ash.sql_id = sql.sql_id
   and ash.session_id = s.sid(+)