Oracle Database Discussions

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!

Understanding limitation of parallel processes

LauryMar 3 2015 — edited Mar 4 2015

Hi,

I have an Oracle 11gR2 EE database that runs using Exadata storage.

I have the following values for parallelism:

SQL> show parameter db_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string OHIBO11A

SQL> show parameter parallel_degree_limit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_degree_limit string 36

SQL> show parameter parallel_degree_policy

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_degree_policy string LIMITED

SQL> show parameter parallel_max_servers

NAME TYPE VALUE
------------------------------------ ----------- ---------------------------
parallel_max_servers integer 36

SQL> show parameter parallel_servers_target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_servers_target integer 36

I observe through Cloud COntrol a series of sessions that have parallelism = 24.
But if I count all the parallelism (thus at instance level) I come out to a value near of 100.
Yet, I have a value of parallel_max_servers = 36.

Can someone explain me why I get this result?

Thanks and Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2015

Added on Mar 3 2015

#general-database-discussions

12 comments

516 views