Re: Reasonable performance ?


frank.van.bortel@xxxxxxxxx wrote:
Adrian Simpson schreef:

We're not entirely sure that we have got a system that is performing
well.

We had a partitioned table with 2254 partitions, of which 260 had data
in, varying between 1 and ~41,000 rows.

The DB is set up to parallelise using 16 processors, but at any one
time, only 8 processes (ora_pxxx_<dbname>) seem to be active.


41k Rows is not much - I would say the overhead for the parallel query
is more than the time it would take to retrieve these.
Although I am not absolutely certain your queries run prallel 8,
I would suggest to take a closer look at your break even point.
Relatively few records are processed faster without parallel query.
What actually is "few" is entirely for you to find out.
My experience is the tbreak even point is
at about 200,000 rows. Different hardware, different setup, so
not comparable at all!

Good point.

.

Relevant Pages

  • Re: Reasonable performance ?
    ... Adrian Simpson schreef: ... We had a partitioned table with 2254 partitions, ... in, varying between 1 and ~41,000 rows. ... Relatively few records are processed faster without parallel query. ...
    (comp.databases.oracle.server)
  • Re: Reasonable performance ?
    ... in, varying between 1 and ~41,000 rows. ... Relatively few records are processed faster without parallel query. ... In the longer run, we would expect 40,000+ rows/partition, but querying could be over several partitions. ... Basically it is a partition per day, and we could be querying over 3 months, so at that we are getting up to a substantial number of rows. ...
    (comp.databases.oracle.server)