达梦数据库查询执行时间长的sql

达梦数据库查询执行时间长的sql

select *
  from (select sess_id,
               sql_text,
               datediff(ss, last_send_time, sysdate) Y_EXETIME,
               sf_get_session_sql(sess_id) full_sql,
               clnt_ip
          from v$sessions
         where state = 'ACTIVE')
 where Y_EXETIME >= 2;