Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: multiple performance
Alexander Smirnov wrote:
> Based the on clock time from the start of the update to the
> completeion of the process.
>
> I want to know how much would simultaneous updates on the same table
> but from the different sessions and on the different rows slow down
> each other. Is it (in rough estimate) a linear function of the number
> of these parallel updates?
There is only one right answer: depends.
As Mladen recommends ... run benchmarks. You will get no where asking for anecdotal advice that may be irrelevant to your application on your hardware with your usage pattern.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Apr 21 2007 - 15:20:05 CDT