Home » RDBMS Server » Server Administration » How to parallelize table partition move operation
How to parallelize table partition move operation [message #235324] Sat, 05 May 2007 00:40 Go to next message
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.
Re: How to parallelize table partition move operation [message #235329 is a reply to message #235324] Sat, 05 May 2007 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You already have the statement.
Which insight do you need?

Regards
Michel
Re: How to parallelize table partition move operation [message #235338 is a reply to message #235329] Sat, 05 May 2007 02:14 Go to previous messageGo to next message
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..!!)
Re: How to parallelize table partition move operation [message #235348 is a reply to message #235338] Sat, 05 May 2007 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: How to parallelize table partition move operation [message #235359 is a reply to message #235324] Sat, 05 May 2007 05:26 Go to previous messageGo to next message
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
Re: How to parallelize table partition move operation [message #235360 is a reply to message #235359] Sat, 05 May 2007 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, the answer is:

it works better on partitioned tables than on others.

Regards
Michel
Re: How to parallelize table partition move operation [message #235371 is a reply to message #235324] Sat, 05 May 2007 06:58 Go to previous messageGo to next message
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..)
Re: How to parallelize table partition move operation [message #235390 is a reply to message #235371] Sat, 05 May 2007 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are also:

parallel_min_percent
parallel_adaptive_multi_user
parallel_automatic_tuning

Regards
Michel
Re: How to parallelize table partition move operation [message #235509 is a reply to message #235324] Mon, 07 May 2007 00:17 Go to previous messageGo to next message
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....?
Re: How to parallelize table partition move operation [message #235511 is a reply to message #235509] Mon, 07 May 2007 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: How to parallelize table partition move operation [message #235572 is a reply to message #235511] Mon, 07 May 2007 04:47 Go to previous message
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:
  


Current Time: Wed Dec 07 04:58:53 CST 2016

Total time taken to generate the page: 0.07720 seconds