Re: Report what tables or columns being used and how often.
Date: Tue, 30 Sep 2008 08:04:00 -0700 (PDT)
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 Received on Tue Sep 30 2008 - 10:04:00 CDT