Re: Oracle lock timeouts

In <mdayton.21_at_stpaul.ncr.com> mdayton_at_stpaul.ncr.com (Mike Dayton) writes:
>In article <23m3vk$ijg_at_pandora.sdsu.edu> oliver_at_io.nosc.mil (George Oliver) writes:

[Lots of stuff deleted]

>The work around of killing the shadow process works only if you can
>identify the process to kill. In version 6 you could not make the
>association between an Oracle PID and a System PID; I don't know if
>it is possible with V7. I have been shutting down the DB each night to
>clean up aborted processes.

I seem to have to do this every day so it can be done. Go into SQL*DBA and use 'monitor user' to find the Oracle user of the PC client that has crashed. Part of this shows the system pid which can then be killed. OK, its a bit awkward and it relies on the user having only one login at the time but it works. This is under Oracle v6 on a SCO Unix server with PC clients connect via FTPs PC/TCP.

Regards

Ian

-- 
--
Ian Dixon                       Email : idixon_at_infocom.co.uk
Reading, England