Re: Oracle scalability issues

From: Hans Forbrich <news.hans_at_telus.net>
Date: Thu, 30 Sep 2004 00:01:38 GMT
Message-ID: <C1I6d.2541$eq.2493@edtnps84>

Jørgen Ruud wrote:

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

Some things to think about ...

What is the meaning of 'SQL Operation' for your context.

Recognize as well that a single SQL statemnt can involve plain disk access, composite disk access (index >> table, etc), multiple concurrent disk accesses, as well as inherent sorting and calculations.

What would you expect to be the difference in CPU cycle between a

SELECT DUMMY FORM DUAL; and possible a select from a view as seen in $ORACLE_HOME/rdbms/admin/catalog.sql

Also, does you analysis include the setup and evaluation of specific optimizers? (e. are you allowing only Rule optimization, or Cost, or mix, etc.)

/Hans Received on Wed Sep 29 2004 - 19:01:38 CDT