Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locks on Bitmap Indexes
sv wrote:
>
> Hi
>
> thank you for your answer. After consulting further documentation I see the
> problem with bitmap indexes.
> But perhaps you can tell something about the second part of my question. My
> application can live with the circumstance that big parts of the table are
> locked because inserts and updates are performed only by very few users.
> The table which is indexed has about 250.000 rows with 15 distinct key
> values. Using B-tree indexes shows significant loss of query performance.
> I would like to check for an index lock on a specific value in order to
> inform the user about the situation.
>
> Do you have an idea ?
>
> Bye
>
> Stephan Voigt
Given that you mention that you already use dbms_lock for some customised locking control, why not include the bitmap key as part of your hashing key to generate lock allocations....Then dbms_lock could be used to implement your locking strategy...?
HTH
--