How to find current value of bind variables in oracle 9i Database.

[Yash99]

Hi
I can see many sql queries doing full table scan in the database, as there is a parameter cursor_sharing='SIMILAR' , Queries are
using bind variables :"SYS_B_2" and :"SYS_B_3 hence it is very difficult to analyse a complex queries with 10 to 15 Bind variable.
Let me know if we can trace the current value of bind variable running in the database?
Can we generate the SQL trace for already running sql queries in the database?

[Yogeeraj_1]

hi,

one easy way is to use the Oracle Enterprise manager. Unfortunately, i have oracle 10g.

There is also a sql command that you can launch to initiate the sql trace of an active session. (i will need to get back to my book for the right syntax/command)

kind regards
yogeeraj

[Eric Antunes · Accepted solution]

Hi,

Check Metalink Note 376442.1 ("Recommended Method for Obtaining 10046 trace for Tuning").

Best Regards,

Eric Antunes

[Yash99]

Thanks eric for your valuable update.