| Indexes doubt [message #278082] |
Thu, 01 November 2007 14:13  |
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  |
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 #278089 is a reply to message #278084] |
Thu, 01 November 2007 14:35 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
