yeah - we stripe our extents over multiple datafiles which are placed and
multiple disks and are accessed over multiple fiberchannel controllers ...
also - don't make the mistake to blow your process runqueue by choosing a
parallel degree which is too high (specially with only 2 cpu's)
"Niko" <nick_wakefield_at_hotmail.com> wrote in message
news:9da94cd1.0205161109.5cef50b1_at_posting.google.com...
> I am not to sure if oracle parallel queries work that well on 2 cpu
> box, unless your running a really large query, over 20 minutes. As the
> associated overhead can make the quert take longer than if running on
> 1 - Well that what I've noticed.
>
> What I would like to ask is this similar to other peoples experience
> and if not did you tune anything in specific to get Oracle to appear
> faster on shorted queires against large tables when running a parallel
> query.
Received on Thu May 16 2002 - 15:09:16 CDT
