Re: lock wait

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 18 Nov 2002 15:36:12 -0000
Message-ID: <NN7C9.29540$zX3.72705@news.indigo.ie>

Make sure you are not serializing resource .

Are you using 'FOR UPDATE OF' ?

Remember, as Mr. Kyte says, writers don't block readers ..

There is indeed a method of tracking back through the V$ tables. You can read about them in the Oracle reference.

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920 /a96536/ch2224.htm#1167058

and other places.
"blue" <blue_at_libertysurf.fr> wrote in message news:newscache$ujcq5h$pa4$1_at_news.tiscali.fr...
> problem lock wait, ora 8.1.6
>
> i have a problem of lock wait n the table with a request.
> How can i determinate the request, that generate the true lock wait and
the
> request that lock the table ?
>
> in level development what s it the solution to avoid the lock wait ?
>
> in ABD, which the configurations solutions of the parameters ( pctfree,
> ilitrans, maxlist...) and the controls ?
>
> thanks
>
>
>
Received on Mon Nov 18 2002 - 09:36:12 CST