Re: Query 60x slower in PL/SQL

http://www.hotsos.com/dnloads/1/10046a/

You have to do the free registration thing ( I have never been spamed by them so I don't think that's an issue) so you might actually want to start at http://www.hotsos.com .

"Vahe Sarkissian" <vahe.sarkissian_at_latimes.com> wrote in message news:510e7b7e.0302200728.54caca8e_at_posting.google.com...
> Ron, thank you for note.
>
> Ron Reidy <rereidy_at_indra.com> wrote in message
news:<3E53FBDF.6050301_at_indra.com>...
>
> > What are the results of an explain plan or tkprof output. If these look
> > good, what about setting event 10046 and looking for waits?
>
> I did try EXPLAIN PLAN, and it looked reasonable. (That's when I
> found out it ran so much faster in SQL*Plus....)
>
> As I mentioned, I'm fairly new to PL/SQL, so I'm not sure how I would
> go about "setting event 10046 and looking for waits".... Could you
> elaborate, or point me at some documentation that explains what that
> is?
>
> Thanks,
> --Vahe Sarkissian
Received on Fri Feb 21 2003 - 21:33:49 CET