查看Oracle数据库执行过的sql

最新推荐文章于 2024-07-18 21:24:26 发布

WaiteH

最新推荐文章于 2024-07-18 21:24:26 发布

阅读量3.4k

点赞数

分类专栏： Oracle SQL

本文链接：https://blog.csdn.net/hwq293/article/details/80132192

版权

Oracle 同时被 2 个专栏收录

25 篇文章 0 订阅

订阅专栏

SQL

12 篇文章 0 订阅

订阅专栏

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;