Re: Interesting problem

From: mhthomas <qnxodba@xxxxxxxxx>
To: vlado@xxxxxxxxxx
Date: Sun, 29 May 2005 23:52:46 -0400

Hi,

On 5/26/05, Vlado Barun <vlado@xxxxxxxxxx> 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

References:

Re: Interesting problem
From: Stephane Faroult

RE: Interesting problem
From: Vlado Barun

Re: Interesting problem

Other related posts: