DBA处理异常常用SQL

--查询执行的SQL
SELECT t.parsing_schema_name,
       t.*
  FROM v$sqlarea t
 WHERE t.parsing_schema_name IN ('APPS')
 ORDER BY t.last_active_time DESC;

--查询会话信息
SELECT t.logon_time,
       t.*
  FROM v$session t
 ORDER BY t.logon_time DESC