--
查询执行的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
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