Parallel hint vs Processors

[goodmans]

Hi Oracle gurus.

I got a situation where i wanted to know more about parallel hints. Please help me.

Server Config:
4 * 1.5GHz UltraSPARC IV+ processors with 2MB on-chip L2 and 32MB L3 cache each, 8 banks of 2GB memory options (32 * 512MB DIMMs / 16B total for the board

I got 4-dualcore processors on my server. How many parallel hints at a time i can use.

I have 6 jobs running parallelly with total 18 parallel options. Is this going to work?

Please help me.

Regards

G

 

[SantaMufasa]

One test is worth 100 expert opinions.

So, what happens when you try it?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[Fattire]

Double the number of processors on your server and use that number in the query's parallel hints.