Re: Monitor usage of columns

Gene and Eric,

Similar to that, you might want to look at the script "dba_column_usage.sql" at http://www.EvDBT.com. I would suggest creating this view in any account other than SYS (such as SYSTEM) so as not to confuse other people or Oracle with thinking that a view named DBA_COLUMN_USAGE is a standard data dictionary view. I use DBA_COLUMN_USAGE as input when deciding on which columns to use as partition-keys, but you can use the information in a variety of ways. I've also created (but not yet posted) a PL/SQL procedure to sample the DBA_COLUMN_USAGE view periodically (a la STATSPACK) so I can add a time component this usage information.

Hope this helps....

Tim Gorman
consultant - Evergreen Database Technologies, Inc. 4651 Highway 73 - suite 308, Evergreen CO 80439

website = http://www.evdbt.com
email   = tim_at_evdbt.com
mobile  = +1-303-885-4526
fax     = +1-303-484-3608

genegurevich_at_discoverfinancial.com wrote:
> Thank you , Eric. This sounds very much like something I am looking for.
>
> thank you
>
> Gene Gurevich
>
>
>
>
>
> "Eric Jenkinson"
> <erichjenkinson_at_g
> mail.com> To
> genegurevich_at_discoverfinancial.com
> 04/20/2007 07:52 cc
> AM oracle-l_at_freelists.org
> Subject
> Re: Monitor usage of columns
>
>
>
>
>
>
>
>
>
>
>
>
> On 4/19/07, genegurevich_at_discoverfinancial.com <
> genegurevich_at_discoverfinancial.com> wrote:
>
> Hi all:
>
> Is there a way in oracle (9i or 10g) to monitor access to the specific
> columns? I'd like to see which of the existing
> columns are never being accesses and remove them. Do I need to set up
> auditing? Or is there another way
> (equivalent to index monitoring for instance)?
>
>
> See if the following thread will be some help.
>
> http://www.freelists.org/archives/oracle-l/05-2004/msg00464.html
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l