Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle scalability issues
"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
![]() |
![]() |