Re: Oracle scalability issues

On Wed, 29 Sep 2004 15:58:16 +0000 (UTC), jorgenru_at_jaguar.stud.ntnu.no (Jørgen Ruud) wrote:

>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.

depends on how the application is written. If the application uses prepared statements shouldn't be a problem, if it doesn't (default) buy another server, and another server, and another server
>- is it usually the memory, the cpu or the disk that is the
>bottleneck, or is it something totaly else. Like memory leaks?
>

Depends on the application. If the developers never tuned their sql statements bottlenecks can possibly occur in all areas. Memory leaks are scarce.
Not tuning sql statements, because not knowing how to do it, is the default.
>>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

You are barking against the wrong tree. More than 80 percent of all performance problems is caused by the application and can't be resolved by adding server capacity.

--
Sybrand Bakker, Senior Oracle DBA