Re: Bitmap index problem

Oracle doesn't lock the table, but
it will be locking a couple of bitmap
entries to do row update - and sometimes if locks a few more entries than it should.

Since a single bitmap entry can cover
several thousand rows, it can give the
appearance of locking the table.

However if you check in v$lock you will find that the table is locked with a mode 3 lock, not a mode 6.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

boris wrote in message <8b7oun$iap$1_at_colt.tsystems.kiev.ua>...
>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.
>
>
>
Received on Tue Mar 21 2000 - 12:18:00 CST