SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

slow performance when SQL queries run in paralleism

887829Oct 22 2013 — edited Oct 23 2013

Hi,

Version-11gR1 , datawarehouse

os linux

When queries are executed in parallel the query is performing very slow.as many such parallel queries run at a time. Previously it was not the case , but as the data is grown now it's taking time.

Please let me know if any parameter to tune to improve parallelism.

Queries are run on big tables ,around 40GB size of tables ..Pls. Advice

CPU utilization is just 20% and 10G memory also is available , only 10% of swapping memory in use.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2013

Added on Oct 22 2013

12 comments

1,173 views