Re: Oracle scalability issues

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 30 Sep 2004 17:58:39 -0700
Message-ID: <1096592398.397049@yasure>

Jørgen Ruud wrote:
> 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.

While you are at it be sure you also use DBMS_ODCI to allow you to compare various CPUs.

A demo can be found at:
http://www.psoug.org
click on Morgan's Library
click on DBMS_ODCI.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Sep 30 2004 - 19:58:39 CDT