Re: find what tables are being used in the database

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