Parallelism with number of CPUs

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Parallelism with number of CPUs

Postby sivakumarocp » Mon Sep 17, 2012 9:19 am

Hi Tim,

I am donig cross platform migraion, for that i need to migrate tablespaces from solaris to linux host. I thought of using PARALLELISM option along with convert tablespace RMAN command but I am bit confused on how much value that i can give for parallelism parameter in RMAN.

in my solaris has 4 physical CPUs with 32G memory.

Code: Select all

oracle:orprod96@admin-vsr256 /oracle > psrinfo
0       on-line   since 09/06/2011 13:52:40
1       on-line   since 09/06/2011 13:52:40
2       on-line   since 09/06/2011 13:52:40
3       on-line   since 09/06/2011 13:52:38

in this case, while doing actual conversion how much value that i can give at the maximum for PARALLELISM parameter in RMAN.

Only one database is running on this host.

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Parallelism with number of CPUs

Postby Tim... » Mon Sep 17, 2012 10:15 am


The answer as always is, it depends.

- If the process is waiting on CPU mostly, then it is pointless using more than one slave per available core or they are just holding each other up.
- If the process is waiting predominantly on factors other than CPU, then adding more slaves that cores is fine from a CPU perspective.
- Parallelism only works if none of the factors affecting it (CPU, memory, network, disk) are bottlenecked. As soon as one or more factors are maxed out, adding more slaves actually reduces performance as it is adding to the bottleneck.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests