Re: Partitioning best practices

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Fri, 1 Sep 2006 14:54:32 -0700
Message-ID: <2ead3a60609011454x5f414947u104987fb64c3ef3@mail.gmail.com>

Boss,

FWIW, Doug Burns had written an excellent article on PQ - you will find it in the archives in the Q3 2005 issue.

> Followup question for you JL in re parallelism: we're having a
> hell of a time deciding how to use parallelsm in regular operations.
> When we have it turned on, any query immediately pops up 8 parallel
> engines and completely hogs all the CPU and i/o channels to the data,
> effectively serializing database access and killing overall performance.
> Is the only way to really figure out what the best solution is
> to just do trial and error with degrees and options til you find
> a workable solution? Or do you even use parallel server outside
> of loading?

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 01 2006 - 16:54:32 CDT