Re: TPC-H Benchmark Optimization

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 14 Jul 2004 22:02:30 -0700 (PDT)
Message-ID: <20040715050230.13951.qmail@web20421.mail.yahoo.com>

• Mogens_Nørgaard <mln_at_miracleas.dk> wrote:
  > Yep, the Full Disclosure Reports available on
  > tpc.org are very detailed,
  > including creation scripts, source code for the
  > benchmarks, etc. So if
  > you look at tpc-c results from Oracle, you'll see
  > that they hardly ever
  > create an index - they use clusters instead. Indexes
  > are too expensive
  > for these folks.
  >
  > Mogens
  >
  > Mogens
  

but a 6g pga_aggregate_target and a 200M db_cache_size?
session_cached_cursors not set?
what were they thinking?

their bchr must have been quite low.
who tunes these things?
have the folks at HP gone completely mad?

Pd

(working out the details to the
othello/scrabble/design a storage subsystem game. hoping to include Master Mind TM in there somewhere. if its half as good as "Drink Monopoly" we could have a winner).

> Paul Drake wrote:
>
> >
> >
> > Raphael,
> >
> > I recall seeing a post by Jonathan Lewis regarding
> the
> > use of single table hash clusters with tpc-c.
> >
> > Aren't the create table scripts usually supplied
> in
> >
>
>

---

> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>

---

> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>

---

>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 23:59:12 CDT