Checking and Rebuilding Database Indexes

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

If database performance falls off significantly, there is a chance that one or more key indexes have become invalid and need to be rebuilt.  

Environment

Data Loss Prevention

Resolution

The following sql script will list all 'protect' owned indexes that do not have the status of valid. If the script returns a value, please contact Broadcom support for next steps.

 

Log into SQLPlus as protect, then run this script:

SELECT index_name, status
FROM user_indexes
WHERE status<>'VALID'
AND index_type<>'LOB';