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 -> Re: Performance problem with PL/SQL procedure

Re: Performance problem with PL/SQL procedure

From: Ronald Rood <devnull_at_ronr.nl>
Date: 16 Apr 2004 03:50:02 -0700
Message-ID: <67ce88e7.0404160250.7c32d25d@posting.google.com>


josesony_at_rediffmail.com (Sony Jose) wrote in message news:<9e2a5204.0404150541.70bd0bd5_at_posting.google.com>...
> 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.

On what hardware do you run, how many cpu's, how is the io organized ? How does the code work ?

Ronald.



http://ronr.nl/unix-dba Received on Fri Apr 16 2004 - 05:50:02 CDT

Original text of this message

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