-
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 ?
svk
-
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 setospid
SVRMGR>oradebug event 10046 trace name context forever, level 4
I found this info in "Oracle8i & UNIX performance tuning" from Alomari
Hope this helps
Gert
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|