Yes i 'm using for update of in two differents procedures
"Telemachus" <telemachus_at_ulysseswillreturn.net> a écrit dans le message
news: NN7C9.29540$zX3.72705_at_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 Tue Nov 19 2002 - 16:51:16 CST
