Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to trigger a capture data for v$sql or v$sql_bind_capture with following conditions? (Oracle10g on Solaris)
Is it possible to trigger a capture data for v$sql or v$sql_bind_capture with following conditions? [message #314379] Wed, 16 April 2008 08:44 Go to next message
salkawari
Messages: 16
Registered: April 2008
Junior Member
Hi there,

is it some how possible to force the data capture of bind variables in either v$sql (bind_data) or v$sql_bind_capture (value_string)
without changing any of the following: cursor_sharing=exact, statistics_level=typical?

Is there some plsql procedure or some alter system command available to do this?

Thanks for your help!
Re: Is it possible to trigger a capture data for v$sql or v$sql_bind_capture with following conditio [message #314380 is a reply to message #314379] Wed, 16 April 2008 08:46 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>is it some how possible to force the data capture of bind variables
Depending upon the definition of "capture".
Using level 12 of SQL_TRACE you can obtain the value of bind variables after the fact.
Re: Is it possible to trigger a capture data for v$sql or v$sql_bind_capture with following conditio [message #314382 is a reply to message #314380] Wed, 16 April 2008 08:51 Go to previous message
salkawari
Messages: 16
Registered: April 2008
Junior Member
do you mean by doing
exec dbms_monitor.SESSION_TRACE_ENABLE(SESSION_ID=>188,SERIAL_NUM=>25183,WAITS=>FALSE,BINDS=>TRUE);
exec dbms_monitor.SESSION_TRACE_DISABLE(SESSION_ID=>188,SERIAL_NUM=>25183);?

If you mean this, is there any other way to make the database sample the current sessions to update the information in V$SQL_BIND_CAPTURE?
Previous Topic: Create SQL string
Next Topic: Select query within trigger
Goto Forum:
  


Current Time: Sun Dec 04 00:38:50 CST 2016

Total time taken to generate the page: 0.11168 seconds