SELECT * FROM v$sql t where t.last_active_time>TO_DATE('2020-12-31 15:00:00','yyyy-mm-dd hh24:mi:ss') and t.PARSING_SCHEMA_NAME = 'YIZY' and sql_text like '%B_SRV_SERVICE_DET%'
Oracle查看最近执行的SQL
最新推荐文章于 2024-05-30 07:33:52 发布
SELECT * FROM v$sql t where t.last_active_time>TO_DATE('2020-12-31 15:00:00','yyyy-mm-dd hh24:mi:ss') and t.PARSING_SCHEMA_NAME = 'YIZY' and sql_text like '%B_SRV_SERVICE_DET%'