Re: Report what tables or columns being used and how often.

From: DA Morgan <>
Date: Tue, 30 Sep 2008 12:02:55 -0700
Message-ID: <>

Jeremy Smith wrote:
> Maybe my last response was miss leading. I know the benefit of this
> types of columns and we have a tone of them. I'm just looking for a
> way to count how often a column is used.
> Do I need to creaet a table to track Column access and add a trigger
> to every table?
> I don't like that idea for several reasons, but not sure if I can
> parse the V$SQL_PLAN.
> Thanks

The best way is to use Oracle's built in auditing or log miner. But do understand that any solution will be very high in overhead and provide essentially no information of value. How often something is accessed is unrelated to its importance.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Sep 30 2008 - 14:02:55 CDT

Original text of this message