Hello all,

I want to share a simple solution for the issue below, when scheduled “Update Statistics” on DB13:

/wp-content/uploads/2016/08/img1_1008358.jpg

/wp-content/uploads/2016/08/img2_1008461.jpg

Error details log:

BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement:

‘BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => ‘”SAPSR3″‘, INDNAME => ‘”/ABC/INDEXNAME~010″‘, ESTIMATE_PERCENT => 3, DEGREE => NULL, NO_INVALIDATE => FALSE); END;’

ORA-20000: index “SAPSR3”.”/ABC/INDEXNAME~010″  or partition of such index is in unusable state

ORA-06512: at “SYS.DBMS_STATS”, line 18683

ORA-06512: at “SYS.DBMS_STATS”, line 18724

ORA-06512: at line 1

Solution

As showing in the log, the index is unusable, so the solution is simple, rebuild it through oracle.

Log on the system server as oraSID, and execute:

sqlplus “/ as sysdba”

alter index “SAPSR3″.”/ABC/INDEX_NAME” rebuild online;

exit;

Regards,

Richard W. L. Brehmer
rbrehmer.com

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply