Hi,
Can anybody explains to me how oracle parallel
server works.

Basically my question is, we have
some 40 processors(nodes), we want to
run 40 oracle parallel servers on those 40 nodes.
We have some expensive queries, which might take
upto 2 days to process in a single node envirnonment,
since we have 40 processors now, will that query
run parallely and get results much sooner ?

Can this be achieved in oracle ?

Thanks.
Sincerley,
Viji