前言
oracle 12.1.0.2.0为了确定功能是否生效,需要查看数据库最近执行的sql语句,在里面找到想要的SQL语句查看数据库最近执行了哪些sql语句
# 查看1小时内执行的sql语句,并按照执行时间倒序排序select s.LAST_ACTIVE_TIME,s.SQL_TEXT,s.SQL_FULLTEXT,s.FIRST_LOAD_TIME,s.LAST_LOAD_TIME,s.EXECUTIONS from v$sql swhere s.SQL_TEXT like '%DUAL%' and s.LAST_ACTIVE_TIME>sysdate-1/24order by s.LAST_ACTIVE_TIME desc
LAST_ACTIVE_TIME : TIme at which the query plan was last active。sql语句最后一次的执行时间。FIRST_LOAD_TIME : Timestamp of the parent creation time.LAST_LOAD_TIME : Time at which the query plan (heap 6) was loaded into the library cache.EXECUTIONS : Number of executions that took place on this object since it was brought into the library cache。执行次数。
如果觉得《【oracle】查看数据库最近执行了哪些sql语句》对你有帮助,请点赞、收藏,并留下你的观点哦!