Home » RDBMS Server » Server Administration » Index rebulding (Linux 2.6.18-92.1.13.el5)
Index rebulding [message #538347] Thu, 05 January 2012 07:07 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Expert,

I am working on Index issue and need to validate the structure of the index. Please confirm, does validation lock the Index ?

Do we need downtime or we can do it in normal working hours.

alter index index_name validate structure;

Thanks
Re: Index rebulding [message #538348 is a reply to message #538347] Thu, 05 January 2012 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please confirm, does validation lock the Index ?

Yes.

The second question is up to you.

Regards
Michel
Re: Index rebulding [message #538350 is a reply to message #538348] Thu, 05 January 2012 07:28 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel.

I will be looking for free on the server.
Re: Index rebulding [message #538790 is a reply to message #538347] Mon, 09 January 2012 08:41 Go to previous messageGo to next message
LNossov
Messages: 318
Registered: July 2011
Location: Germany
Senior Member
I suppose, you mean ANALYZE, not alter.

There is an ONLINE option for validate structure.
Re: Index rebulding [message #538791 is a reply to message #538790] Mon, 09 January 2012 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I do not see any ALTER word in this topic (but yours).

Thanks for the ONLINE option.

Regards
Michel
Re: Index rebulding [message #538794 is a reply to message #538347] Mon, 09 January 2012 08:55 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Michel:

dba_7722 wrote on Thu, 05 January 2012 13:07

alter index index_name validate structure;

Re: Index rebulding [message #538811 is a reply to message #538794] Mon, 09 January 2012 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm blind today! /forum/fa/1606/0/

Regards
Michel
Re: Index rebulding [message #538920 is a reply to message #538811] Tue, 10 January 2012 06:42 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Sorry Michel,

It was mistakenly written 'alter'.

May i please ask what is difference between analyze index with online option and without. I read with online option,no statistics are gathered, the process only validates the integrity of the object.
Re: Index rebulding [message #538922 is a reply to message #538920] Tue, 10 January 2012 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is correct and locks should be held for less time but I never tested it, maybe you can do it and tell us.

Regards
Michel
Re: Index rebulding [message #538923 is a reply to message #538922] Tue, 10 January 2012 06:58 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel,

Will do and surely update the forum.
Previous Topic: RCA Report
Next Topic: multiple log.xml files
Goto Forum:
  


Current Time: Fri Mar 29 09:08:58 CDT 2024