Re: Oracle scalability issues

• Post for FREE via your newsreader at post.usenet.com ****

Jørgen Ruud wrote:

> Hello,
> I'm writing my masters thesis on "scalability of a web system". This
> system uses a Oracle 9.0.3 RAC DB. I wonder if there exists any known
> scalability problems with this database?.

> I'm doing some calculations and wonder if anyone know how many
> CPU instructions a SQL operations in Oracle needs (just a rough number, are
> we talking 10^6 or 10^7), and how many clock cycles does it need to
> complete?

> Thanks in advance.

Jorgen, do you mean other than the basic scalability question concerning RAC to begin with? Any application that runs on a RAC setup could probably be ran faster on a single SMP machine with processing power equal to the total of the RAC system.

Being that version 9.0 did not survive very long in the field before 9.2 was released I would recommend you use 9.2.0.4 or higher if possible. We skipped 9.0 upgrading from 8.1.7.4 OPS to 9.2.0 RAC rather than deal with the slew of published 9.0 bugs.

HTH -- Mark D Powell --

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=