Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bitmap index problem
Hi !
Oracle does not lock the entire table. This is the case where
oracle places a page lock on the rows affected. For sure, if you
have a table and the data in the indexed column are all the same
then a
lock on the entire table takes place. For further information
look at the documentation for bitmap indexes.
Regards,
Mario Bucsics