Parallelism with number of CPUs

All posts relating to Oracle database administration.

Moderator: Tim...

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.
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Parallelism with number of CPUs

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

Hi.

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.

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests

cron