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

From: Jeremy Smith <>
Date: Tue, 30 Sep 2008 07:07:34 -0700 (PDT)
Message-ID: <>

Thanks for the help. How often is V$SQL_PLAN populated?

Does anyone know a good way to parse the columns ACCESS_PREDICATES, FILTER_PREDICATES & PROJECTION to get just columns? as you can imagine they come in all kinds of formats.

My goal is to create a report of how often a column is being access to justify and priorities them moving to our new DB.

Thanks again Received on Tue Sep 30 2008 - 09:07:34 CDT

Original text of this message