OraFAQ Forum: SQL & PL/SQL » How to find wether procedure is running or not

Home » SQL & PL/SQL » SQL & PL/SQL » How to find wether procedure is running or not

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find wether procedure is running or not [message #8019]

Tue, 22 July 2003 07:43

shashi
Messages: 34
Registered: March 2001

Member

Hi
Iam running a procedure and it is running from past 3 hours and i dont know wether it is still running or hanging how to find that,can any one guide me.
Thank in advance
shashi

Report message to a moderator

Re: How to find wether procedure is running or not [message #8037 is a reply to message #8019]

Tue, 22 July 2003 20:59

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

Try querying v$session_longops, especially the time_remaining column.

Report message to a moderator

Previous Topic:	Prompting for value in create library statement
Next Topic:	Why can't we use * and column name of same column in select statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:47:24 CDT 2024