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: 3211
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: 21806
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 /forum/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: 26766
Registered: January 2009
Location: SoCal
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 Mar 29 09:07:04 CDT 2024