IANAL_VISTA wrote:
> 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 <===
Demos of DBMS_SUPPORT functionality can be found in Morgan's Library
at www.psoug.org.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Nov 14 2005 - 09:43:30 CST
