OraFAQ Forum: Server Administration » How to parallelize table partition move operation

Home » RDBMS Server » Server Administration » How to parallelize table partition move operation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to parallelize table partition move operation [message #235324]

Sat, 05 May 2007 00:40

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

Need to get an insight on the parallel option specified with the 'alter table table_name move partition partion_name tablespace tablespace_name parallel x.

Report message to a moderator

Re: How to parallelize table partition move operation [message #235329 is a reply to message #235324]

Sat, 05 May 2007 01:32

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You already have the statement.
Which insight do you need?

Regards
Michel

Report message to a moderator

Re: How to parallelize table partition move operation [message #235338 is a reply to message #235329]

Sat, 05 May 2007 02:14

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

if anyone can let me know if the parallel threads are invoked similar to tat in a normal table...or does a partion behave in some other way....(doubts raised as the partition is taking too long to move inspite of parallel 15..! 50 min for 4 G..!!)

Report message to a moderator

Re: How to parallelize table partition move operation [message #235348 is a reply to message #235338]

Sat, 05 May 2007 04:27

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you have a sufficient IO bandwith to support 15 parallel processes or are they waiting each other an IO?
Next do you 15 free CPUs or are your processes waiting each other for CPU wasting their time waiting for being scheduled?

Did you check that?

Regards
Michel

Report message to a moderator

Re: How to parallelize table partition move operation [message #235359 is a reply to message #235324]

Sat, 05 May 2007 05:26

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

System Configuration: Sun Microsystems sun4u Sun Fire 6800
System clock frequency: 150 MHz
Memory size: 98304 Megabytes
No of CPUs : 48

Heres the system configuration..I dont think there would have been a IO bandwidth problem.., nor does the above configuration seem to be short on CPUs.. The normal tables with the same size were moved in comparatively lesser time..!! So wanted to know y partiotioned tables behave otherwise.... Smile

Report message to a moderator

Re: How to parallelize table partition move operation [message #235360 is a reply to message #235359]

Sat, 05 May 2007 05:33

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I dont think there would have been a IO bandwidth problem

You don't have to think, you have to prove (not for me but for you).
Watch your IO rate, service time, queue... to see if there is no problem.
If you think there is a problem, you have to find where there are waits. Execute statspack to see if Oracle reports anything.

Regards
Michel

[Updated on: Sat, 05 May 2007 05:34]

Report message to a moderator

Re: How to parallelize table partition move operation [message #235361 is a reply to message #235324]

Sat, 05 May 2007 05:49

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

Thnaks for the reply...but lets get bak to my question...Does the parallel option work the same way on a normal table and a partitioned one...(the command in the very first post.) The system on which the operation was performed is a perfectly well working system... I jst wanted to confirm the concepts used...

[Updated on: Sat, 05 May 2007 05:50]

Report message to a moderator

Re: How to parallelize table partition move operation [message #235364 is a reply to message #235361]

Sat, 05 May 2007 06:43

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So, the answer is:

it works better on partitioned tables than on others.

Regards
Michel

Report message to a moderator

Re: How to parallelize table partition move operation [message #235371 is a reply to message #235324]

Sat, 05 May 2007 06:58

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

now tat invokes my curiosity again..!!I'm jst moving a partition at a time using the parallel option... Mind explaining wat is it tat makes it faster...? and if there are any parameters tat come into consideration..?? (know abt parallel_max_servers for one..)

Report message to a moderator

Re: How to parallelize table partition move operation [message #235390 is a reply to message #235371]

Sat, 05 May 2007 08:20

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are also:

parallel_min_percent
parallel_adaptive_multi_user
parallel_automatic_tuning

Regards
Michel

Report message to a moderator

Re: How to parallelize table partition move operation [message #235509 is a reply to message #235324]

Mon, 07 May 2007 00:17

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

Thanks for the reply sir... but the settings of the parameters tat u mentioned in no way would restrict a parallel statement would it..?? I have parallel_min_percent = 0 Let me put up my questions more objectively now.. Would a moving a partition using the parallel option invoke x threads similar to wat happens with a normal table....?

Report message to a moderator

Re: How to parallelize table partition move operation [message #235511 is a reply to message #235509]

Mon, 07 May 2007 00:24

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

but the settings of the parameters tat u mentioned in no way would restrict a parallel statement would it..??

Of course they would, they determine when and how Oracle will use parallelism.

Quote:

Would a moving a partition using the parallel option invoke x threads similar to wat happens with a normal table

Yes.

Regards
Michel

Report message to a moderator

Re: How to parallelize table partition move operation [message #235572 is a reply to message #235511]

Mon, 07 May 2007 04:47

hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai

Junior Member

Tat final 'Yes' pretty much sums up wat i've been looking for..Thanks a looott....for replying every single time..!! Be back again with more queries soon...

[Updated on: Mon, 07 May 2007 04:49]

Report message to a moderator

Previous Topic:	help on unix command
Next Topic:	SVRMGRL and SQLPLUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 17:10:29 CST 2025