Regarding Parallelism in RMAN

All posts relating to Oracle database administration.

Moderator: Tim...

Regarding Parallelism in RMAN

Postby sivakumarocp » Mon Jul 23, 2012 9:32 am

Hi Tim,

I am trying to do cross platform migraion from solaris to linux host.
my source db has (125G in size) but got only 2 hrs downtime to migrate to Linux host.
I need to convert two tablespace.(where the customer data resides). during the RMAN tablespace convert process if I am using parallelism 6 or 8 will it speed upthe process ( note : those two tablespaces has 11 datafiles each).
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Regarding Parallelism in RMAN

Postby Tim... » Mon Jul 23, 2012 10:00 am

Hi.

The answer to that is, "it depends".

For any parallel task, things will only work faster in parallel if there are no limiting factors. For example, lets say I am performing a task in a single threaded fashion and I am maxing out my disk I/O (or CPU or memory), then attempting to perform the same operation in parallel will actually slow down the process, since I now have multiple slaves fighting over the same I/O subsystem.

So, assuming you have no limits on your system, using parallel will increase performance, but as soon as you hit a bottleneck, adding more slaves will actually reduce performance.

As with everything, the only way to find out is to run a test.

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: 17952
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 1 guest