Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.mailgate.org!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
From: "Michele Campagni" <michele.campagni@libero.it>
Newsgroups: comp.databases.oracle.server
References: <44080a87$0$29112$5fc30a8@news.tiscali.it> <1141379982.512484.262190@z34g2000cwc.googlegroups.com>
Subject: Re: Oracle benchmark
Date: Fri, 3 Mar 2006 11:38:02 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Lines: 51
Message-ID: <44081c8e$0$29115$5fc30a8@news.tiscali.it>
Organization: Tiscali SpA
NNTP-Posting-Host: 84.220.118.244
X-Trace: 1141382286 news.tiscali.it 29115 84.220.118.244:10859
X-Complaints-To: abuse@tiscali.it
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262678

<sybrandb@yahoo.com> ha scritto nel messaggio 
news:1141379982.512484.262190@z34g2000cwc.googlegroups.com...
> The best hint I can give you is to read the Oracle Concepts manual, and
> the Performance Tuning manual.

ok.

> You are wasting your time, as you don't seem to understand anything
> about how the buffer cache mechanism works. You are up to an exercise
> in futility, because Oracle never has the complete database in SGA.

I think the same thing but it's a thesis for my degree, my professor ask me 
to put all database in SGA, so if it's possible (but seems not) I have to do 
it...

> Even if it would have been possible, the figures you call 'benchmarks'
> would be completely irrelevant once the database starts growing.

The db is generate by 'tpc-h dbgen' and it don't grows. I have several query 
to execute, like this, in wich I have to eliminate I/O access to do an 
speed-up test. Test is about growing in speed when I increase number of 
fisical processors (Solaris and Sparc environment).

select
        l_returnflag,
        l_linestatus,
        sum(l_quantity) as sum_qty,
        sum(l_extendedprice) as sum_base_price,
        sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
        sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
        avg(l_quantity) as avg_qty,
        avg(l_extendedprice) as avg_price,
        avg(l_discount) as avg_disc,
        count(*) as count_order
from
        lineitem
where
        l_shipdate <= date '1998-12-01' - interval '62' day (3)
group by
        l_returnflag,
        l_linestatus
order by
        l_returnflag,
        l_linestatus;


I did many tests but never be able to stop I/O access. But if you say SGA 
never contains entire DB I belive it.
Tanks for the answer and forgive me for my bad english.