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@xxxxxxxxx> 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@xxxxxxxx> 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. >