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

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