Bitmap index block concurrence

    技术2026-08-13  2

    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.

     

     

     

    最新回复(0)