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

From: Jeremy Smith <godtoall_at_hotmail.com>
Date: Tue, 30 Sep 2008 08:04:00 -0700 (PDT)
Message-ID: <60e83e93-0f03-44a2-b246-f3df01aa6bd1@h60g2000hsg.googlegroups.com>


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

Original text of this message