OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » parallel DDL (oracle 10g)

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

parallel DDL [message #464627]

Thu, 08 July 2010 09:33

arunprasad_bh
Messages: 32
Registered: June 2007

Member

Hi,
Is it possible to build index partition in parallel?

I tried following command

alter index <index_name> rebuild partition <partition name> online parallel 5;

It executed without complaining, but want to know if index partitions can be build in parallel?

Thanks for your help.

Arun

Report message to a moderator

Re: parallel DDL [message #464629 is a reply to message #464627]

Thu, 08 July 2010 09:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It executed without complaining, but want to know if index partitions can be build in parallel?
What does EXPLAIN PLAN show?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: parallel DDL [message #464631 is a reply to message #464627]

Thu, 08 July 2010 09:50

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

Senior Member
Account Moderator

Now what could we answer you? Yes, no, would you trust us? I advice you no.
Execute your statement and have a look if some Pxxx processes work.

You have to first enable parallel DDL with an ALTER SESSION statement.

Regards
Michel

[Updated on: Thu, 08 July 2010 09:52]

Report message to a moderator

Re: parallel DDL [message #464647 is a reply to message #464631]

Thu, 08 July 2010 10:46

arunprasad_bh
Messages: 32
Registered: June 2007

Member

Thanks. I ran the command and found entries in v$px_session and v$px_process

Report message to a moderator

Previous Topic:	excess redo generation
Next Topic:	SQL Query Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 05:52:24 CST 2024