Re: "ps -ef" in oracle

From: Gerhard M <notruf_1102003_at_yahoo.de>
Date: 12 Oct 2004 08:03:42 -0700
Message-ID: <942c5b0d.0410120703.52e5fb2@posting.google.com>

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<od9nm0db0mri9oqaamuebs0tpbb40j024k_at_4ax.com>...
> SELECT *
> FROM
> v$session
> where type = 'USER'
> and status = 'ACTIVE'

that might be a 'who'. I'll see detailed informations, but no information about the currently executed statement.

Maybe my question wasn't clear:

someone started:
SQL> exec SOME_PROC(params)
2 /

this procedure will take some hours.
How do i check if SOME_PROC is still running.

gerhard Received on Tue Oct 12 2004 - 10:03:42 CDT