Toad World® Forums

How can i retrieve current sql parameter using session browser?

Hi,

i met a problem

i am monitoring the current sql used by my program using the session browser tool, i can catch the sql statement but i have no idea how to catch the parameter used by it?

anyone can teach me how to do it? many thanks!!

Are you using binds?

You can try to see if your query is cached, check the SGA (Database > Monitor

SGA Trace) and there’s an option to enable bind peeking.

Otherwise, you can trace your session being sure to trace it at a level that
will capture binds. You’ll then need to use TkProf or Toad’s Trace
File Browser to interpret the results.

Jeff

Hi Jeff,

Many thanks for your help

yes, i use binding parameters in Application Program

Could you give more detail steps for how to catch up the bind parameter? i am just using TOAD for the first time and i am not familiar with it.

Man thanks.

Yinbo

The only 100% accurate way to do this is with a Session Trace

We added support for displaying bind values if possible in the SGA Trace window,
with a few disclaimers.