> On Thu, 13 Nov 2003 22:53:39 +0100, "Erik" <no_at_spam.com> wrote:
>
> >> Predicate Information (identified by operation id):
> >> ---------------------------------------------------
> >>
> >> 1 - filter("CC"."ATT"='C1')
> >> 5 - access("AC"."ACCOUNT"="CC"."ACCOUNT"(+))
> >
> >How do I do to see this information?
>
> Provided you have Oracle 9.2, look up DBMS_XPLAN, and when you create
your
> PLAN_TABLE make sure you use the latest version of the table definition,
from
> $ORACLE_HOME/rdbms/admin/utlxplan.sql.
>
> Do an explain plan as normal "explain plan for select * from wherever",
then
> do "select * from table(dbms_xplan.display())".
Is there any possibility to see the Predicate information with 8.1.7?
Received on Fri Nov 14 2003 - 15:39:08 CST
