Home » RDBMS Server » Server Administration » Need to know the status of the Anonymous Block program (oracle version 10g Windows XP)
Need to know the status of the Anonymous Block program [message #538245] Wed, 04 January 2012 22:33 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 10:46:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.