Re: lock wait

Lock on table is application side problem. To get the request have a look on v$sqlarea and v$session. You can also put your database in trace. See the documentation.

An important thing is to put index on all foreign key. I had to do that to eradicate locks on my databases.

Regards
Yel.

blue wrote:
> 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 - 02:40:02 CST