Re:
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "Bernard Polarski" <bpolarsk@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 May 2006 20:00:50 +0800
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts: