Re: find what tables are being used in the database
- From: rjamya <rjamya@xxxxxxxxx>
- To: john.hallas@xxxxxxxx
- Date: Thu, 14 Jun 2007 11:36:33 -0400
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.
Other related posts:
