Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle scalability issues

Re: Oracle scalability issues

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 30 Sep 2004 00:20:17 GMT
Message-ID: <4jI6d.133406$MQ5.55123@attbi_s52>

"Jørgen Ruud" <jorgenru_at_jaguar.stud.ntnu.no> wrote in message news:slrncllmso.90v.jorgenru_at_jaguar.stud.ntnu.no...
> Mark D Powell wrote:
> >Jorgen, do you mean other than the basic scalability question concerning
> >RAC to begin with?
>
> The sort of scalability i think about is:
> - what will happen if the DB expiriences a doubling, trebling, ten fold
> increase in number of operations per second.
> - is it usually the memory, the cpu or the disk that is the
> bottleneck, or is it something totaly else. Like memory leaks?
>
> >was released I would recommend you use 9.2.0.4 or higher if possible. We
> Sorry this was a typo, the system already runs on 9.2.0.X
>
> --
> Jørgen Ruud
> jorgenru_at_stud.ntnu.no

Usually the application sucks so that is the biggest problem by far. If you use bind variables, and reuse cursors and follow the application developer recommendations it will scale rather well. Also depends on what sql and is it an oltp system or a data wharehouse? Makes a big difference. Jim Received on Wed Sep 29 2004 - 19:20:17 CDT

Original text of this message

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