Re: [SQL TUNING]The bind variables in a query

jbmorla_at_gmail.com wrote in
news:1131980345.973564.161100_at_o13g2000cwo.googlegroups.com:

> Hi,
>
> What do I do when I find:
>
> SELECT XXX, YYY, FROM ZZZ ....
> WHERE XXX = BindVariable:
>
> in the shared pool,
>
> and I want to perform an explain plan on that query?
>
> Obviously depending on the number of rows selected, my SQL tuning
> strategy varies a lot.
>
> I need to know the value in the variable at runtime.
>
> If anyone has an idea, please let me know.
>
>

desc dbms_support
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE START_TRACE_IN_SESSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT <===