Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Yash99
Occasional Advisor

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

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?

3 REPLIES
Yogeeraj_1
Honored Contributor

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor
Solution

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

Hi,

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

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Yash99
Occasional Advisor

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

Thanks eric for your valuable update.