:

RSSIndexes

ALTER INDEX MONITORING USAGE

In order to maintain an efficient database, it can be very useful to prune indexes from time to time as the system usage changes. An index that may have been used very often when the schema was first designed, may not be used after a new code release for example. It’s also common when implementing […]

Continue Reading

Wait Event enq: TX – allocate ITL entry

Oracle Version: 10.2.0.4 Platform: Windows Server 2003, SP2 Our system had steadily been getting busier and busier, as the business grew and more customers start using the system. Up until now the system has been performing quite well; the AWR reports don’t show any unwanted wait events and the SQL queries have been tuned nicely […]

Continue Reading

ORA-20000: index or partition of such index is in unusable state

ORA-20000: index or partition of such index is in unusable state

The Problem During one of our overnight jobs which gathers statistics on several tables after having data loaded into them, the job failed with the ORA-20000 error message. The problem was because we had a partition splitting job which ran against the table which caused the indexes to become unusable after the partition had been […]

Continue Reading