Gerhard M wrote:
> 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
try
select * from v$session_longops where time_remaining>0;
Received on Tue Oct 12 2004 - 10:12:06 CDT
