Re: Locked table in Oracle

You can configure sqlnet to detect dead connections. Check out the V$SESSION view to determine the current sessions. Then you can use an ALTER SYSTEM KILL SESSION to get rid of the connection.

Terry Dykstra (TeamPS)

René Rolander Nygaard <rrn_at_lyin.dk> wrote in article <856967710.494_at_dejanews.com>...
> From PowerBuilder i do an update, then a Commit ;
> The application will try to re-connect, if it should happend to
 disconnect
> from the server.
> To test this i did this :
> UPDATE concurrency-table ;
> Pulled the net-cable from the computer
> COMMIT - which failed, due to the lost net-cable.
> Reconnect every 10 second until a new connect.
> Plugged the net-cable in
> reconnected
>
Received on Wed Feb 26 1997 - 00:00:00 CET