Which reminds me, try and see whether you are lucky to have some extended statspack (seg stats or plans) history or AWR in which you will find the names of objects being in use.
 

Vlad Sadilovskiy
Oracle Database Tools
http://www.fourthelephant.com

 

On 6/14/07, rjamya <rjamya@gmail.com> wrote:

I'd look at v$segstat ... and/or enable table monitoring. Monitoring will tell you if there has been any dml against it, v$segstat will tell you if anyone selected from it by looking at lio numbers.

IMHO this is more lightweight than auditing.

Raj

On 6/14/07, Hallas, John (EXP N-ARM) <john.hallas@lmco.com > wrote:

Auditing is probably  the best get, although there may be monthly, annual or ad-hoc tables that might take a time to appear in the audit tables.