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: What to do? Many updates and selects

Re: What to do? Many updates and selects

From: <sybrandb_at_yahoo.com>
Date: 2 Jun 2005 08:22:18 -0700
Message-ID: <1117725738.325626.213190@o13g2000cwo.googlegroups.com>


Thousands of updates shouldn't be a problem for a normal properly tuned configuration, and a normal, properly developed, app. If they don't use bind variables everything becomes a whole different story, in that case your cpu will choke and rocket sky-high.

Given that, scenario 1 is overkill and scenario 2 is a recipe for disaster if you don't know what you are doing.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jun 02 2005 - 10:22:18 CDT

Original text of this message

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