2 Replies Latest reply: Sep 2, 2012 10:52 AM by user1779355 RSS

    creation of bitmap index taking long time

    user1779355
      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