Re: Parallel Query option on SMP-boxes. Yes or no?

Gert Struyven wrote:
>
> Hi there,
>
> At our site we are about to implement SMP-boxes of IBM.
> Now, Oracle claims that you need the Parallel Query Option to run smoothly
> on this machines.
>
>
>
> I'd appreciate to receive any help.
>
> Thanks in advance.
>
> --
> Gert Struyven
> Manager DBA-departement
> ABP
> PO BOX 4862
> 6401 JP Heerlen
> The Netherlands

We find that PQO gives benefits mainly in the the data warehousing/ decision support style stuff, but negligible benefits for our day to day OLTP stuff...

But remember that PQO also gives major benefits for those operations that are not necessarily conducted when the users are on the system:

1. index creation/rebuild
2. data loading thru SQL Loader
3. data recovery

all which may reduce downtime either planned or unplanned...

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin