Re: Tuning of a stored oracle procedure

From: Keith Boulton <boulke_at_globalnetnospam.co.uk>
Date: Sun, 04 Oct 1998 10:56:43 GMT
Message-ID: <36161390.3996606@news.globalnet.co.uk>

On Fri, 02 Oct 1998 15:20:48 GMT, a_andy_at_my-dejanews.com wrote:

>Hi! Everybody,
>
>This is a procedure which i want to tune. Presently it takes 10 minutes for
>execution. The required indexes are in place.
>
>Any suggestions ???
>
>Thanks in advance.
>

Too many cursors, re-code using joins in sql and where clauses to move most of the processing out of the pl/sql code. This will run much faster. Received on Sun Oct 04 1998 - 05:56:43 CDT