How to modify bind var capture interval in 10gr2

In 10gr2, you can capture the value of SQL variable binding. for efficiency, it is captured every 15 minutes. I have previously introduced the capture of SQL variable binding in an article, here we will not introduce how to view the captured bind variables. The following describes how to modify Bind Variable capture interval:

A hidden parameter _ cursor_bind_capture_interval is introduced in 10gr2 to control the frequency of capturing Bound variables. to disable the capture of Bound variables, set statistics_level to basic. If statisitcs_level is set to basic, it may affect the collection of other maintenance information.

SQL & gt; Set pages 9999
SQL> set lines 121
SQL> Col ksppinm format A36
SQL> Col ksppstvl format A18
SQL> Col ksppdesc format A54
SQL> select ksppinm, ksppstvl, ksppdesc
2 from x $ ksppi Pi, x $ ksppcv CV
3 where cv. indx = pi. indx and PI. ksppinm like '_ % 'escape''
4 and PI. ksppinm like '% & Parameter % ';
Enter value for parameter: _ cursor_bind_capture_interval
Ksppinm ksppstvl ksppdesc
-------------------------------------------------------------------------
_ Cursor_bind_capture_interval 900 interval (in seconds) between two bind capture for a cursor