As a DBA, how do you know or where to get , what are all the binding variables used by an Oracle user in his SQL statement?
Do you mean actual variables or values used in executing the SQL statement that has bind variable in it ?
I mean values of the bind varaiables.
you can use sql_trace to establish this.
execute the following command before your user execute the statements
alter session set events = '10046 trace name context forever, level 4'
this generates lot's of info in the trace file.
You can find the values of the bind variables in the trace file.
Or you can do it using svrmgr
SVRMGR>oradebug event 10046 trace name context forever, level 4
I found this info in "Oracle8i & UNIX performance tuning" from Alomari
Hope this helps
Click Here to Expand Forum to Full Width