REPOST: 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: <2$--$%%%%--%%%$$%$@news.noc.cabal.int>

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

WAS CANCELLED BY =======: From: Sybrand Bakker <postbus_at_sybrandb.demon.nl> Control: cancel <0g935ukliavqft2cplvb8cocvme39b8tvp_at_4ax.com> Subject: cmsg cancel <0g935ukliavqft2cplvb8cocvme39b8tvp_at_4ax.com> Date: Mon, 28 Jan 2002 02:28:03 GMT Message-ID: <cancel.0g935ukliavqft2cplvb8cocvme39b8tvp_at_4ax.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!fu-berlin.de!area.cu.mi.it!news.mailgate.org!news2.euro.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716255

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 12:38:25 CST