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

From: <srivenu_at_hotmail.com>
Date: Thu, 18 Sep 2008 10:57:50 -0700 (PDT)
Message-ID: <53f0e4ad-44d8-4901-b8de-b782cc3df4d0@g17g2000prg.googlegroups.com>

You could use sys.COL_USAGE$.
This is actually used by the dbms_stats package while generating column statistics.
regards
srivenu Received on Thu Sep 18 2008 - 12:57:50 CDT

This message: [ Message body ]
Next message: srivenu_at_hotmail.com: "Re: load data"
Previous message: sybrandb_at_hccnet.nl: "Re: Problems that can ocuur while upgrading from 9i 1o 10g"
In reply to: Jeremy Smith: "Report what tables or columns being used and how often."
Next in thread: Jeremy Smith: "Re: Report what tables or columns being used and how often."
Reply: Jeremy Smith: "Re: Report what tables or columns being used and how often."
Reply: fitzjarrell_at_cox.net: "Re: Report what tables or columns being used and how often."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message