Home » Other » General » How to know recently run Procedures (10g)
How to know recently run Procedures [message #405400] Wed, 27 May 2009 09:44 Go to next message
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???
Re: How to know recently run Procedures [message #405402 is a reply to message #405400] Wed, 27 May 2009 09:55 Go to previous messageGo to next message
ThomasG
Messages: 3122
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.

Re: How to know recently run Procedures [message #405437 is a reply to message #405402] Wed, 27 May 2009 15:01 Go to previous messageGo to next message
Littlefoot
Messages: 19887
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/
Re: How to know recently run Procedures [message #405450 is a reply to message #405400] Wed, 27 May 2009 21:29 Go to previous message
BlackSwan
Messages: 23146
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.
Previous Topic: Oracle Service Registry on Windows Server 2008
Next Topic: Mismatch Between Body/Spec PL/SQL package
Goto Forum:
  


Current Time: Fri Dec 19 10:59:40 CST 2014

Total time taken to generate the page: 0.13502 seconds