This discussion is archived
2 Replies Latest reply: Sep 2, 2012 8:52 AM by user1779355 RSS

creation of bitmap index taking long time

user1779355 Newbie
Currently Being Moderated
Hi
I have OLTP compression enabled on the table

CREATE BITMAP INDEX
I1 ON
T1(
col 1Asc
)
NOLOGGING TABLESPACE ts_index01

taking very long time.

The wait event is : cell single block physical read.

Any ideas what I can do?

Thank u

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points