Do you have auditing turned on ?

-----Original Message-----
From: Islam Farhadul
[mailto:oracledba-ezmlmshield-x55921139.[Email address protected]
Sent: Monday, September 13, 2004 2:20 PM
To: LazyDBA Discussion
Subject: RE: How to find out when a table was used last time?



Hi All,

I need to find out which table in a database hasn't been used much so it
can be removed from the database. Now, is there way (i.e. doing query
against a data dictionary) to figure out which table has been used over
last 6/12 months and which table hasn't been used.

Any help would be highly appreciated.


Regards,

FI



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page