My Oracle Support Banner

Table with Many Bitmap Indexes Has Slow Index Maintenance after Load Abort or Rollback (Doc ID 2906964.1)

Last updated on FEBRUARY 21, 2024

Applies to:

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


DML on a table with many bitmap indexes has slow index maintenance when the load is aborted or rolled back.   This causes the next DML on the table to be extremely slow.  The exact number of indexes at which this issue starts to occur was not determined, but there were 75 bitmap indexes on the table in the testcase provided.


 While this issue was first reported under 18c, it had occurred for the same customer under, as well.  It is unknown if it also occurred in 11g.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.