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

From: <srivenu_at_hotmail.com>
Date: Sat, 20 Sep 2008 12:24:15 -0700 (PDT)
Message-ID: <711f943e-ae11-42ec-999c-eb6cbc2e6e65@r15g2000prd.googlegroups.com>

I dont think there is a straight forward way to do this. You can query & store OBJECT_OWNER, OBJECT_NAME, OBJECT_ALIAS, OBJECT_TYPE, ACCESS_PREDICATES, FILTER_PREDICATES & PROJECTION columns from V$SQL_PLAN frequently and then use PL/SQL code to check what columns in DBA_TABLES are being referred. regards
srivenu Received on Sat Sep 20 2008 - 14:24:15 CDT

This message: [ Message body ]
Next message: Palooka: "Re: SQLPLUS driver"
Previous message: srivenu_at_hotmail.com: "Re: Full table scan performance differences - why?"
In reply to: Jeremy Smith: "Re: Report what tables or columns being used and how often."
Next in thread: Mladen Gogala: "Re: Report what tables or columns being used and how often."
Reply: Mladen Gogala: "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