Re: Looping tasks

In article <603622877wnr_at_youngman.demon.co.uk>, Jeremy_at_youngman.demon.co.uk (Jeremy Youngman) says:
>
>Are there are Oracle users who have, or have had, problems with "looping"
>tasks? For example if a database user does not end his session cleanly
>then when the database is shutdown the user's task (still in a broken
>state on the system) suddenly starts looping? I've had advice about the
>use of "sig-hup" and "keep-alive", but we still have problems from time
>to time so I'm hoping for a "been there, done that, got the T-shirt"
>person who could offer some advice?

We have users logging in and starting runform30 sessions from telnet windows on PCs (pc/nfs telnet). If they close windows, switch off, or crash their pc (as in "honest, I didn't do anything"), the runform30 sessions spin on the CPU (0% idle). We have not yet found anything to do about this except kill the runform30 when it happens.

SunOS 4.1.3, csh, seen it with V6 and V7.

iain.

--

..............................................................................
Iain Massey   Information Services Manager
              J-Corp Pty Ltd             ACN 009 063 076    "Building the
              Perth, Western Australia                        spirit of
Phone:        +61 9 340 3555                               free enterprise"
Fax:          +61 9 340 3504
Email:        iain_at_jcorp.DIALix.oz.au
..............................................................................