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

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org