Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem with PL/SQL procedure
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.