[ale] OT: Hung session, process sleeping? (Sun/Solaris/Oracle)

[Ken Cochran]

Sorry for the OTness but I thought someone here might know...
Reply off-list if desired.  OS is Solaris on a Big Sun Thing
Running True Evility... :p

Hey ALErs, friend of mine hit me with this & I'm kinda lost, thought
I'd ask y'all.

Date: Tue, 22 Mar 2011 12:21:33 -0500
Subject: Hung session, process sleeping?

Here's the skinny:

Ssh'ed into the box and launched an oracle import (imp) and let it run and
spit out whatever errors to stdout.

After a period of time my ssh client generated a buffer overflow (this is
the second time running this command that this has happened, both times were
after several hours of running)
At the moment, it appears that the process is sleeping, and this is
confirmed with prstat and time not changing via ps:

  oracle  3163  3111  0 14:11:12 pts/3   99:48 imp system/redacted full=y
grants=y ignore=y
  oracle  3847  3773  0 12:08:38 pts/2    0:00 grep imp

It still shows me as being logged in on the other session (I haven't clicked
the 'close' button on the error message)

User     tty           login@  idle   JCPU   PCPU  what
oracle   pts/2        10:40am     2                w
oracle   pts/3        Mon 1pm 21:59 308:43 308:36  (redacted)

Basically this is what I'd like to do:
detatch the process and allow it to finish, getting output from it at this
point is a bit of a moot point anyway, they're going to want to run various
scripts to check stuff after the fact to catch errors.
When it crashed the first time and I closed the application,
it terminated the process, and when this one hosed up I was
a good 17 hours into the new import. Obviously hindsight is
20/20 and if I have to crank it over yet again it'll be with
several new command line switches and output redirects, but I'd
like to avoid that and move straight to the process finishing,
if possible.

Thanks!

-kc