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

From: Jeremy Smith <>
Date: Tue, 30 Sep 2008 08:04:00 -0700 (PDT)
Message-ID: <>

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