Re: Report what tables or columns being used and how often.
Date: Sat, 20 Sep 2008 12:24:15 -0700 (PDT)
I dont think there is a straight forward way to do this. You can query & store OBJECT_OWNER, OBJECT_NAME, OBJECT_ALIAS, OBJECT_TYPE, ACCESS_PREDICATES, FILTER_PREDICATES & PROJECTION columns from V$SQL_PLAN frequently and then use PL/SQL code to check what columns in DBA_TABLES are being referred. regards
srivenu Received on Sat Sep 20 2008 - 14:24:15 CDT