在10g以前的版本,是不能捕获bind var的实参的,但在10gR2是可以捕获bind var的实际参数值.为了降低系统的压力,bind data capture与Modification Monitoring一样,都采用15min钟取样一次...

select statistics_name, description, session_status
from V$STATISTICS_LEVEL
where statistics_name = 'Bind Data Capture'

1 Bind Data Capture Enables capture of bind values used by SQL statements ENABLED

测试如下:

SQL> var vname varchar2(32);
SQL> exec :vname := '_assm_default';

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01
SQL> select count(*) from para_all where name = :vname;

COUNT(*)
----------
1

SQL> select sql_id from v$sql where sql_text = 'select count(*) from para_all where name = :vname';

SQL_ID
-------------
0dah9yd0bfuw8

SQL> select value_string
2 from V$SQL_BIND_CAPTURE
3 where sql_id = '0dah9yd0bfuw8';

VALUE_STRING
-------------------------------------------------------------------
_assm_default