Re: Interesting problem

From: mhthomas <qnxodba_at_gmail.com>
Date: Sun, 29 May 2005 23:52:46 -0400
Message-ID: <d6bad0800505292052305ebf5b@mail.gmail.com>

Hi,

On 5/26/05, Vlado Barun <vlado_at_cadre5.com> wrote:
> Dave

>=20

> , another possibility is to put the query in question into a stored
> procedure, which starts a 10046 trace when called, and stops the trace af=
ter
> the query completes.

>=20
> A restriction of this approach is that you wouldn't see the stat lines, b=
ut
> you would see the waits, parse, fetch exec,...

>=20

> The stat lines are written only after the cursor closes (see
> http://asktom.oracle.com/pls/ask/f?p=3D4950:61:::::P61_ID:17000122666475 =
)

I would test dbms_sql.close_cursor() before saying *impossible*. :-)

Regards,

Mike Thomas

--
http://www.freelists.org/webpage/oracle-l

Received on Sun May 29 2005 - 23:57:37 CDT