Home » RDBMS Server » Server Administration » Indexes doubt
Indexes doubt [message #278082] Thu, 01 November 2007 14:13 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
Hi i am trying to find a way to check that all indexes are fine (not corrupted)
is there a way to check it?
i know that alert.log shows when a index crash... is there a way to check them?
thnx in advance
Re: Indexes doubt [message #278083 is a reply to message #278082] Thu, 01 November 2007 14:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
User_indexs
all_indexes
dba_indexes

Check the status for INVALID

user_ind_partitions
all_ind_partitions
dba_ind_partitions

check status for UNUSBALE
Re: Indexes doubt [message #278084 is a reply to message #278082] Thu, 01 November 2007 14:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i know that alert.log shows when a index crash... is there a way to check them?
HUH? Please post an example of an "index crash".

SELECT INDEX_NAME, STATUS FROM DBA_INDEXES;
Re: Indexes doubt [message #278089 is a reply to message #278084] Thu, 01 November 2007 14:35 Go to previous message
thorin666
Messages: 144
Registered: March 2007
Senior Member
anacedent wrote on Thu, 01 November 2007 14:17

>i know that alert.log shows when a index crash... is there a way to check them?
HUH? Please post an example of an "index crash".

SELECT INDEX_NAME, STATUS FROM DBA_INDEXES;


sorry, i mean corrupted/unusable maybe

Previous Topic: how to solve shared memory realm problem (merged)
Next Topic: errors to overcome
Goto Forum:
  


Current Time: Mon Nov 04 11:46:36 CST 2024