OraFAQ Forum: SQL & PL/SQL » Percentage of index rebuild

Home » SQL & PL/SQL » SQL & PL/SQL » Percentage of index rebuild (Oracle 10.2.0.2.0 ,solaris)

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

Percentage of index rebuild [message #397027]

Wed, 08 April 2009 12:12

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi ,

How will one know that how much percentage of index is rebuild ,while rebuilding index?

Regards,
Balaji

Report message to a moderator

Re: Percentage of index rebuild [message #397031 is a reply to message #397027]

Wed, 08 April 2009 12:20

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

v$session_longops possibly, depending on your configuration.

Report message to a moderator

Re: Percentage of index rebuild [message #397109 is a reply to message #397031]

Thu, 09 April 2009 00:58

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks for the answer.

Report message to a moderator

Re: Percentage of index rebuild [message #397125 is a reply to message #397027]

Thu, 09 April 2009 02:46

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Usual question - why are you rebuilding your indexes?

Report message to a moderator

Re: Percentage of index rebuild [message #397180 is a reply to message #397027]

Thu, 09 April 2009 05:41

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

SELECT * 
FROM   v$session_longops
WHERE sofar!=totalwork

Report message to a moderator

Re: Percentage of index rebuild [message #397409 is a reply to message #397125]

Fri, 10 April 2009 09:11

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi,

I'm not going to rebuild indexes now.i just want to know the answer for my question.may be in the future it may be required.

Regards,
Balaji

Report message to a moderator

Re: Percentage of index rebuild [message #397410 is a reply to message #397027]

Fri, 10 April 2009 09:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How will one know that how much percentage of index is rebuild ,while rebuilding index?
100% The whole index is rebuilt.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: Percentage of index rebuild [message #397420 is a reply to message #397410]

Fri, 10 April 2009 10:07

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Im sorry for this time.will follow the rules from next time.

Report message to a moderator

Previous Topic:	delete duplicate
Next Topic:	Help in using Anlytical function for a requirement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 04:03:20 CST 2025