Re: Speed of Oracle8 ?

Assume a simple query takes 4 logical I/Os. Total logical I/O requirement for 700 simple queries: 2,800

Two extreme cases:

    All logical I/Os are met in memory
    Oracle can typically handle 10,000 logical I/Os per second per 100 MHz CPU.
    So a relatively low power box could easily handle your queries.

    Assume each query results in one physical read:     700 queries per second => 700 I/Os per second.     Typical (multi user) I/O rates peak around 50 I/Os per second     You need a minimum of 14 discs to handle 700 queries per second

        (even though the database is only 4Gb).

Basically - your original question cannot be answered until you have determined the actual requirement of your database.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

C. Fischer wrote in message <7mv41h$j7g$2_at_news00.btx.dtag.de>...
>Problem:
>Project with about 700 Queries per second
>(from simple lookup to very complex queries).
>Too much for Oracle8?
>Datavolume: more than 4GB.
>And what hardware is needed if it is possible with Oracle8?
>It would be helpful to know if 700 simple queries could be answered in
>one second.
>
>bye
>cf
>
>
Received on Sun Aug 01 1999 - 10:07:59 CDT