Re: find what tables are being used in the database

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

--
http://www.freelists.org/webpage/oracle-l