Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: May 24, 2017 - 12:23 pm UTC

Last updated: June 02, 2017 - 3:07 am UTC

Version: 12.1.0

Viewed 1000+ times

You Asked

As i have seen everyday in alert.log of database it is showing like this -

online index (re)build cleanup: objn=128483 maxretry=2000 forever=0

Can you please let me know why it is showing ?

Thanks


and Connor said...

From MOS

Alert Log Messages Online Index (re)build Cleanup Appearing Repeatedly (Doc ID 2088016.1)

In this Document
Symptoms
Changes
Cause
Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
SYMPTOMS

On 12.1.0.2, alert log contains below messages repeatedly.

online index (re)build cleanup: objn=1082690 maxretry=2000 forever=0
CHANGES

No Changes .

CAUSE

SMON is attempting to cleanup the index repeatedly.

SOLUTION

This is an SMON standard process that runs periodically. SMON is attempting to clean up the index repeatedly.

Index needs to be dropped and recreated .

For example :

DROP INDEX ix_emp_01 ;

CREATE INDEX ix_emp_01 ON emp(ename)
TABLESPACE users
STORAGE (INITIAL 20K
NEXT 20k
PCTINCREASE 75);

Rebuilding the index could also help :
ALTER INDEX ix_emp_01 REBUILD ONLINE;

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

oracle oracle, June 01, 2017 - 6:53 am UTC

Thanks for reply.

It is internal SMON Task or we need to work with this or we can ignore it.


Connor McDonald
June 02, 2017 - 3:07 am UTC

See in the note:

"Index needs to be dropped and recreated"

So look for the index with object id 128483