Re: Is process alive?

Yes,
query the v$sesstat table for that specific session.

Hth,

Sybrand Bakker, Oracle DBA

Karol Michaliak wrote:

> Hi,
>
> how can I find, that an oracle process is still alive and working? I
> use
> a select from v$session table. I see, that STATUS is ACTIVE, COMMAND
> is 6, which mean, that the process is doing UPDATE. Is there a
> pssibility to see a disc aktivity of this process?
> Thanks,
>
> Karol Michaliak
> DB admin

Received on Fri Dec 11 1998 - 05:48:47 CST