Re: Report what tables or columns being used and how often.
Date: Tue, 30 Sep 2008 07:07:34 -0700 (PDT)
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