OraFAQ Forum: General » How to know recently run Procedures

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

Show: Today's Messages :: 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: 3212
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: 21823
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/

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: 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.

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: Tue Nov 26 04:26:18 CST 2024