Re: Query 60x slower in PL/SQL

From: Vahe Sarkissian <vahe.sarkissian_at_latimes.com>
Date: 20 Feb 2003 07:28:17 -0800
Message-ID: <510e7b7e.0302200728.54caca8e_at_posting.google.com>

[Quoted] Ron, thank you for note.

Ron Reidy <rereidy_at_indra.com> wrote in message news:<3E53FBDF.6050301_at_indra.com>...

[Quoted] > 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 Thu Feb 20 2003 - 16:28:17 CET

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Application Server light ?"
Previous message: Vahe Sarkissian: "Re: Query 60x slower in PL/SQL"
Maybe in reply to: Vahe Sarkissian: "Query 60x slower in PL/SQL"
In reply to Ron Reidy: "Re: Query 60x slower in PL/SQL"
Next in thread: Sybrand Bakker: "Re: Application Server light ?"
Reply: Christopher Boyle: "Re: Query 60x slower in PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message