查看Oracle数据库执行过的sql

最新推荐文章于 2025-08-01 10:07:25 发布

原创最新推荐文章于 2025-08-01 10:07:25 发布 · 3.5k 阅读

5 ·

CC 4.0 BY-SA版权

Oracle 同时被 2 个专栏收录

25 篇文章

订阅专栏

SQL

12 篇文章

订阅专栏

select sql_text,last_load_time from v$sql order by last_load_time desc;
SELECT   sql_text, last_load_time FROM v$sql WHERE last_load_time IS NOT NULL and sql_text like 'select%' ORDER BY last_load_time DESC;
SELECT   sql_text, last_load_time FROM v$sql WHERE last_load_time IS NOT NULL and sql_text like 'update%' ORDER BY last_load_time DESC;
SELECT   sql_text, last_load_time FROM v$sql WHERE last_load_time IS NOT NULL and last_load_time like' 14-06-09%' ORDER BY last_load_time DESC;