Re:

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 19 May 2006 20:00:50 +0800
Message-ID: <074501c67b3b$e16f6a20$6401a8c0@porgand>

> 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

Received on Fri May 19 2006 - 07:00:50 CDT