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: multiple performance

Re: multiple performance

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 21 Apr 2007 13:20:05 -0700
Message-ID: <1177186806.127584@bubbleator.drizzle.com>


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.org
Received on Sat Apr 21 2007 - 15:20:05 CDT

Original text of this message

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