Title: RE: Identification of tables NOT being used in the System.
There was a note previously on a similar theme which I have posted below.
The dba_tab_modifications does not show when a table has been selected from which could be a problem for reference data type table which can easily be
ALTER TABLE tablename MONITORING;
Every three hours or so, the SYS.DBA_TAB_MODIFICATIONS view gets updated
with the tables UPDATEs, DELETEs, and INSERTs, as well as wether or not the
table has been TRUNCATEd since the last time it was DBMS_STATS'd. The view
also gets updated on a SHUTDOWN,
There is the vil way ... just drop the table and see who screams :)
Alec
-Original Message-
Dharminder
Sent: Friday, March 15, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L
In our production database environment, I have a list of about 1000 tables
,for which we want to
Dharminder,
Instead of the overhead of auditing, how about periodic queries of
V$SQL_Text for SQL statements that reference those tables. It should be
pretty easy to come up with occurrences and counts for each table, though
statements using bind variables could cause low counts for the tables