Home » SQL & PL/SQL » SQL & PL/SQL » Percentage of index rebuild (Oracle 10.2.0.2.0 ,solaris)
Percentage of index rebuild [message #397027] Wed, 08 April 2009 12:12 Go to next message
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
Re: Percentage of index rebuild [message #397031 is a reply to message #397027] Wed, 08 April 2009 12:20 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
v$session_longops possibly, depending on your configuration.
Re: Percentage of index rebuild [message #397109 is a reply to message #397031] Thu, 09 April 2009 00:58 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks for the answer.
Re: Percentage of index rebuild [message #397125 is a reply to message #397027] Thu, 09 April 2009 02:46 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Usual question - why are you rebuilding your indexes?
Re: Percentage of index rebuild [message #397180 is a reply to message #397027] Thu, 09 April 2009 05:41 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
SELECT * 
FROM   v$session_longops
WHERE sofar!=totalwork
Re: Percentage of index rebuild [message #397409 is a reply to message #397125] Fri, 10 April 2009 09:11 Go to previous messageGo to next message
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

Re: Percentage of index rebuild [message #397410 is a reply to message #397027] Fri, 10 April 2009 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Percentage of index rebuild [message #397420 is a reply to message #397410] Fri, 10 April 2009 10:07 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Im sorry for this time.will follow the rules from next time.
Previous Topic: delete duplicate
Next Topic: Help in using Anlytical function for a requirement
Goto Forum:
  


Current Time: Fri Dec 09 13:47:29 CST 2016

Total time taken to generate the page: 0.05643 seconds