v$sql_bind_capture view包含了SQL绑定变量的信息

1.此view中只保存最后一次捕获SQL的变量信息
2.两次捕获之间的间隔为900s，受隐藏参数控制

SQL> @?/yccs
Enter value for value: capture
old 4: AND ksppinm like '%&value%'
new 4: AND ksppinm like '%capture%'

KSPPINM KSPPSTVL KSPPDESC
--------------------------------------------- ---------- ------------------------------------------------------------
_cursor_bind_capture_area_size 400 maximum size of the cursor bind capture area
_cursor_bind_capture_interval 900 interval (in seconds) between two bind capture for a cursor

yccs.sql内容如下:
set linesize 160
set pagesize 100
col ksppinm format a45
col ksppstvl format a10
col ksppdesc format a60
SELECT ksppinm, ksppstvl, ksppdesc
FROM x$ksppi x, x$ksppcv y
WHERE x.indx = y.indx
AND ksppinm like '%&value%';

3.只对where后面的变量进行捕获
4.也可以通过dba_hist_sqlbind查询历史绑定变量信息
dba_hist_sqlbind的信息是从v$sql_bind_capture里面采集的

ITPub博客

[Oracle] v$sql_bind_capture & dba_hist_sqlbind

最新文章