oracle 数据库监控
SELECT LAST_ACTIVE_TIME,PARSING_SCHEMA_NAME,SQL_TEXT, ,SQL_FULLTEXT FROM v$sql WHERE LAST_ACTIVE_TIME>TO_CHAR('2021/01/25 13:00:00','YYYY/MM/DD HH24:mi:ss')
ORDER BY LAST_ACTIVE_TIME DESC
oracle 数据库监控
SELECT LAST_ACTIVE_TIME,PARSING_SCHEMA_NAME,SQL_TEXT, ,SQL_FULLTEXT FROM v$sql WHERE LAST_ACTIVE_TIME>TO_CHAR('2021/01/25 13:00:00','YYYY/MM/DD HH24:mi:ss')
ORDER BY LAST_ACTIVE_TIME DESC
本文标题:Oracle 查询SQL执行历史记录日志
本文链接:https://www.haomeiwen.com/subject/njhizktx.html
网友评论