Oracle Database Discussions

Hello gurus,

I need some help here, my parallel queries always been downgrade, i'dont understand why it's always happen, can u help me to figure it out and give me the solution how i can repair that.

Here is the spec of my server :
• O/S: HP-UX B.11.11
• Server Type: HP RP8400
• Server Name: DWHETL
• IP : 10.128.1.24
• CPU : 4
• Memory: 16 GB
• Oracle: Oracle 10G
• Oracle SID: tm1dev (existing)
• Storage: 2 TB External Storage
• Multipath:PVlink
• Volume Management: LVM

The parameter i set are :
- alter system set sga_max_size=8G scope=spfile;
- alter system set sga_target=8G scope=spfile;
- alter system set pga_aggregate_target=4G scope=spfile;-
- alter system set parallel_min_servers=4 scope=spfile;
- alter system set parallel_max_servers=8 scope=spfile;
- alter system set dbwr_io_slaves=8 scope=spfile;
- alter system set open_cursors=500 scope=spfile;

Really need your help to solve this problem. thx