Re: Performance problem with PL/SQL procedure

If your crontabs work on the same rows of data in the database, they you'll be seeing locking issues.

If you used 8i (not sure about earlier versions), you could've used some PL/SQL debugging tools to figure out how long each step of PL/SQL takes.

Also trace some sessions, the bottleneck is sql most likely.

On 15 Apr 2004 06:41:21 -0700, josesony_at_rediffmail.com (Sony Jose) wrote:

>Hi,
>
>I have some stored procedures that are pretty time consuming. (They
>have been optimized to the maximum extend - very little to be done on
>that now). These procedures need to be executed repeatedly for a range
>of input parameters (batch processing from unix cron job).
>
>In order to work around this situation, we designed the cron job to
>create multiple background processes accessing the stored procs (each
>for a different range of inputs). Our assumption was that, this way,
>the processing time will be less than that for using a single unix
>process to invoke the procedures for the entire range of input.
>However, we are finding that the processing time is actually the same
>in both cases.
>
>Could someone please tell us whether there's a solution for this
>(maybe we need to change some settings somewhere?). Or is this how it
>works in Oracle? (We're using 7.3.4, by the way.) Any help will be
>appreciated.
>
>Regards,
>Sony Jose.

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Apr 15 2004 - 14:25:41 CDT