Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creation of bitmap index taking long time

user1779355Sep 1 2012 — edited Sep 2 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2012

Added on Sep 1 2012

#exadata, #index, #performance-availability

2 comments

670 views