OraFAQ Forum: General » How to know recently run Procedures

Home » Other » General » How to know recently run Procedures (10g)

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

How to know recently run Procedures [message #405400]

Wed, 27 May 2009 09:44

beetel
Messages: 96
Registered: April 2007

Member

We have a sort of 'dirty' database. I'd like to know which objects are actually used in production, and drop those which are not. For instance, which procedures were run recently, or tables which were read recently... Is this possible???

Report message to a moderator

Re: How to know recently run Procedures [message #405402 is a reply to message #405400]

Wed, 27 May 2009 09:55

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

Senior Member

I don't know of a way for "recently".

But you can try the v$access data dictionary view for "now", and then maybe run a query on that every five minutes for a week or so and store the results.

Report message to a moderator

Re: How to know recently run Procedures [message #405437 is a reply to message #405402]

Wed, 27 May 2009 15:01

Littlefoot
Messages: 16971
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Or, hm, drop them all and create one by one as soon as users start to cry ./fa/917/0/

Report message to a moderator

Re: How to know recently run Procedures [message #405450 is a reply to message #405400]

Wed, 27 May 2009 21:29

BlackSwan
Messages: 20099
Registered: January 2009

Senior Member

What happens with a procedure that produces annual report?
It can remain unused for 11+ months.
Is this considered "recent"?
This cleanup effort & inherent risk likely out weighs the "cost" of disk space reclaimed.

I hope you save/retain DDL for any & all dropped objects.

Report message to a moderator

Previous Topic:	Oracle Service Registry on Windows Server 2008
Next Topic:	Mismatch Between Body/Spec PL/SQL package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 03:03:41 CDT 2013

Total time taken to generate the page: 0.11663 seconds