Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: tuning sql statement with bind value

Re: tuning sql statement with bind value

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 Jan 2002 19:38:25 +0100
Message-ID: <0g935ukliavqft2cplvb8cocvme39b8tvp@4ax.com> 





On Fri, 25 Jan 2002 11:57:00 -0600, "Kevin Brand"
<kevin.brandx_at_tel.gte.com> wrote:



>

>AUTOTRACE=true doesn't work unless you bind the variables and execute the

>statement, however the following does work:

>



set autotrace explain stat


however *does* work. Always!



Regards




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Fri Jan 25 2002 - 12:38:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US