Re: Oracle benchmark

<sybrandb@xxxxxxxxx> ha scritto nel messaggio
news:1141379982.512484.262190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: ORA-04031 with Collections and SGA Settings
    ... I am working with a data warehouse using an Oracle 10g R1 database. ... SGA MAX SIZE: 5904 MB ... Do the settings for the SGA raise any questions/comments/concerns? ...
    (comp.databases.oracle.server)
  • Re: too many files....
    ... and growing at the rate of about 300-500/month. ... One of the work machines has a hardRAID-5 of 72G 7200 RPM SCSI disks, ... is just a fileserver, though, not a web or database server.) ...
    (comp.os.linux.misc)
  • RE: Information Store (DB) & Transaction logs growing to fast/ to quic
    ... the new one continue growing, actually did not, then with begun moving 30 ... users at a time to the new database from the old one, ... then we move another 30 mailboxes and the new database begun to ... also I'm trying to Exchange User Monitor to check if the DB begin to grow ...
    (microsoft.public.exchange.misc)
  • Re: PRIMARY filegroup is full - no its not!
    ... Processes are filling your DB, your DB is virtually full, Autogrow kicks in, ... no more space as the DB is still growing. ... Database is set to unrestricted file growth. ... > the database thinks there is no free space on the drive. ...
    (microsoft.public.sqlserver.server)
  • Re: limiting/controlling MDB File Size
    ... you can't prevent the file from growing. ... keep tables in a separate database and link you client end to it. ... code window and compact and repair. ... decompile once a month or so ...
    (microsoft.public.access.setupconfig)