Database DataWarehousing (MOSC)

MOSC Banner

Creation time of a bitmap index?

edited Apr 17, 2012 11:13PM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi,
11.2.0.2

A developer complained that her bitmap index creation has taken over two hours.

The table itself is partitioned and consists of over 150 million rows. Not much else going on in the DB.

CREATE BITMAP INDEX dw.TEST_INDEX
   ON dw.TEST_TABLE (R_KEY)
   LOCAL
   LOGGING
   TABLESPACE MARIDX
   COMPUTE STATISTICS

There are over 13 000 distinct values for R_KEY
The current wait is;: library cache lock - which have been the current one for the last 30 minutes.

As I have never created a bitmap index my self, what is expected? I gathered statistics on the table after the complaint, it lacked stats.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center