test@ORCL>create table t(processed_flag varchar2(1));
Table created.
test@ORCL>create bitmap index t_idx on t(processed_flag);
Index created.
Create a bitmap index on table t;
test@ORCL>insert into t values('N');
1 row created.
Insert value 'N' into table t at one session,do not commit;
test@ORCL>insert into t values('N');
At the second session,insert value 'N' ,transaction will be blocked.