Re: Monitor usage of columns
- From: Tim Gorman <tim@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- Date: Wed, 25 Apr 2007 12:01:47 -0600
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@xxxxxxxxx
mobile = +1-303-885-4526
fax = +1-303-484-3608
genegurevich@xxxxxxxxxxxxxxxxxxxxx wrote:
Thank you , Eric. This sounds very much like something I am looking for.
thank you
Gene Gurevich
"Eric Jenkinson"
<erichjenkinson@g
mail.com> To
genegurevich@xxxxxxxxxxxxxxxxxxxxx
04/20/2007 07:52 cc
AM oracle-l@xxxxxxxxxxxxx
Subject
Re: Monitor usage of columns
On 4/19/07, genegurevich@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> 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.
//www.freelists.org/archives/oracle-l/05-2004/msg00464.html
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
