查看最近用户使用过的sql语句

最新推荐文章于 2022-03-04 14:37:20 发布

ForKing_

最新推荐文章于 2022-03-04 14:37:20 发布

阅读量631

点赞数

分类专栏：日常sql pl/sql

本文链接：https://blog.csdn.net/toratto/article/details/11639831

版权

日常sql pl/sql 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

  1  select /* recetsql */ sql_id,child_number,hash_value,address,executions,sql_text
  2  from v$sql
  3  where parsing_user_id =(select  user_id from all_users
  4  where username=upper('&uname'))
  5  and command_type in (2,3,6,7,189)
  6* and upper(sql_text)  not like upper('%rece%')

对于v$sql字段的

SQL_TEXT VARCHAR2(1000) First thousand characters of the SQL text for the current cursor --返回当前游标的sql 文本

SQL_ID VARCHAR2(13) SQL identifier of the parent cursor in the library cache--返回在库缓存中父游标的id号

EXECUTIONS NUMBER Number of executions that took place on this object since it was brought into the library cache --返回当前对象在库缓存中被执行的次数

PARSING_USER_ID NUMBER User ID of the user who originally built this child cursor --生成这个子游标的用户iD

CHILD_NUMBER NUMBER Number of this child cursor ---子游标的个数

HASH_VALUE NUMBER Hash value of the parent statement in the library cache --当前语句在库缓存中的哈希值

COMMAND_TYPE NUMBER Oracle command type definition

关于command_type的几种类型：

Insert 2
Select 3
Update 6
Delete 7
Lock Table 26
Alter Database 35
Alter Session 42
Commit 44
Rollback 45
Savepoint 46
Begin/Declare 47