Re: Oracle scalability issues

From: Jørgen Ruud <jorgenru_at_tiger.stud.ntnu.no>
Date: Thu, 30 Sep 2004 09:42:12 +0000 (UTC)
Message-ID: <slrnclnl7k.iul.jorgenru@tiger.stud.ntnu.no>

In article <C1I6d.2541$eq.2493_at_edtnps84>, Hans Forbrich 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?

>What is the meaning of 'SQL Operation' for your context.
For this will e.g be a TCP-B operation, read one tuppel, write one tuppel, update two tuppels. Some simple standard operation.

What I'm after here is a simple: "stick our finger in the air, and give me a feel" on the numbers i'm requesting. It is just so i get an indication on the cpu usage a simple database operation use.

-- 
Jørgen Ruud
jorgenru_at_stud.ntnu.no

Received on Thu Sep 30 2004 - 04:42:12 CDT