Re: "ps -ef" in oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 13 Oct 2004 19:07:52 -0700
Message-ID: <1097719759.140057@yasure>

Bricklen wrote:

> 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;

And look at the built-in package DBMS_APPLICATION_INFO.

A full demo of the longops capability can be found at: http://www.psoug.org
Click on Morgan's Library
Click on DBMS_APPLICATION_INFO
Scroll to the bottom of the page.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Oct 13 2004 - 21:07:52 CDT