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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
