OraFAQ Forum: Server Administration » Need to know the status of the Anonymous Block program

Home » RDBMS Server » Server Administration » Need to know the status of the Anonymous Block program (oracle version 10g Windows XP)

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

Need to know the status of the Anonymous Block program [message #538245]

Wed, 04 January 2012 22:33

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Happy New year to you all.

Need your help on the below question.

One of our developers team member had created a Anonymous block program to do something in the Database, and he forgotten and terminated the session without confirming the program's status, whether it was fully ran or not.

Is there any way to check out the status of this, which happened yesterday?

Regards
Muktha

Report message to a moderator

Re: Need to know the status of the Anonymous Block program [message #538246 is a reply to message #538245]

Wed, 04 January 2012 22:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any way to check out the status of this, which happened yesterday?
DBMS_LOGMNR shows all DML against the DB, but it is hard to see activity that did not occur.
Does anyone know what they are looking for?
How will you or anyone know what the correct answer is supposed to be?

Report message to a moderator

Re: Need to know the status of the Anonymous Block program [message #538249 is a reply to message #538245]

Wed, 04 January 2012 23:35

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

A small correction on the above post.

That was not a Anonymous Block program. It was a Procedure.

Regards
Muktha

Report message to a moderator

Re: Need to know the status of the Anonymous Block program [message #538254 is a reply to message #538249]

Thu, 05 January 2012 00:48

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no such thing than history of procedure execution status (whatever this means).

Regards
Michel

Report message to a moderator

Previous Topic:	How to shrink a tables size?
Next Topic:	how to read dump contents

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 19:03:24 CST 2025