Re: Bitmap index problem

boris wrote:
>
> Hi everybody.
> Is anybody know the problem like here.
> I have the table and bitmap index on this table.
> Why oracle lock the ehtire table (not the record) when I
> update,delete,insert record?
> thanks in advance.

Bitmap indexes will look all rows with the same value when you issue a DML. For example, if you have 5 distinct values and you update one, then 20% of the table is locked (until commit).

If you have 2 distinct values and you update one to another - then the whole table is locked..

This is why the doco casually mentions that bitmaps are not typically suitable for OLTP.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse