Re: "ps -ef" in oracle

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 12 Oct 2004 11:37:32 +0200
Message-ID: <od9nm0db0mri9oqaamuebs0tpbb40j024k@4ax.com>

On 12 Oct 2004 00:49:22 -0700, notruf_1102003_at_yahoo.de (Gerhard M) wrote:

>hi,
>
>i'm looking out for something like ps -ef within oracle.
>I need to know if a procedure, executed by an other user/on an other
>terminal, is still running.
>At unix i'll find currently active commands with ps -ef|grep XXX. Is
>there somthing equal within oracle?
>
>thx
>
>gerhard

SELECT *
FROM
v$session
where type = 'USER'
and status = 'ACTIVE'

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Oct 12 2004 - 04:37:32 CDT