Re:


There is no mention of the predicate had coded selected value : OWNER='SYS' So I will not be able to generated a statement
to count the number of rows with the filter OWNER='SYS'. but up to know this is the closer to what I am looking for.

You'll get the predicates from v$sql_plan.access_predicates and filter_predicates after parsing or from plan_table if you use explain plan.

Tanel. 

--
http://www.freelists.org/webpage/oracle-l


Other related posts: