OraFAQ Forum: Performance Tuning » verify if procedure has been completed

Home » RDBMS Server » Performance Tuning » verify if procedure has been completed (Oracle 10.2.0.3, Jsp 2.0)

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

verify if procedure has been completed [message #506593]

Tue, 10 May 2011 03:08

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Is there a way to know if a procedure has been completed/ still running?

Regards
Ved

Report message to a moderator

Re: verify if procedure has been completed [message #506594 is a reply to message #506593]

Tue, 10 May 2011 03:12

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You could set something in client_info in v$session at the start of the procedure and unset it at the end. Then you see in v$session if the procedure is running, and from which session.

Report message to a moderator

Re: verify if procedure has been completed [message #506597 is a reply to message #506594]

Tue, 10 May 2011 03:29

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

You can query v$sql, this was when I was executing a procedure called testproc

orcl> select sql_text,users_executing from v$sql where sql_text like '%testproc%';

SQL_TEXT
--------------------------------------------------------------------------------
USERS_EXECUTING
---------------
select sql_text,users_executing from v$sql where sql_text like '%testproc%'
              1

BEGIN testproc; END;
              1


orcl>

Report message to a moderator

Previous Topic:	Table occupying max size
Next Topic:	ORA-01555

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:09:27 CDT 2024