Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performance problem with PL/SQL procedure

Performance problem with PL/SQL procedure

From: Sony Jose <josesony_at_rediffmail.com>
Date: 15 Apr 2004 06:41:21 -0700
Message-ID: <9e2a5204.0404150541.70bd0bd5@posting.google.com>


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. Received on Thu Apr 15 2004 - 08:41:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US