How to see Predicates in xplan display?

From: Ben <balvey_at_comcast.net>
Date: 4 May 2007 09:23:54 -0700
Message-ID: <1178295834.160371.234770@c35g2000hsg.googlegroups.com>

9.2.0.5 EntEd AIX5L

What do I have to do to turn on the predicates display for xplan.display? I've been using Sql Developer a little here recently and notice that when you do an explain plan in there it is supposed to show the predicate information related to each step. Well it isn't working. I haven't been able to get it to work using xplan.display either though. I'd would guess that it's a setting maybe a parameter that I don't have selected but I'm not sure. My compatible parameter is set to 8.1.0 but the opt_feat_enable is set to 9.2.0 Here's a sample of what I get.

SQL> explain plan set statement_id = 'abc'   2 for
  3 SELECT syedoc,
  4 sydoco
  5 FROM proddta.f47011
  6 WHERE sypnid = 'DOC'
  7 AND syedsp = 'Y'
  8 AND sycrmd = ' '
  9 ORDER BY syedoc;

Explained.

SQL> SELECT * FROM
TABLE(dbms_xplan.display('PLAN_TABLE','abc','ALL'));

PLAN_TABLE_OUTPUT

| 0 | SELECT STATEMENT | | 9 | 279
| 14 |
| 1 | SORT ORDER BY | | 9 | 279
| 14 |
| 2 | TABLE ACCESS BY INDEX ROWID| F47011 | 9 | 279
| 12 |
| 3 | INDEX RANGE SCAN | F47011_1 | 28 |
| 1 |

Note: cpu costing is off, PLAN_TABLE' is old version

11 rows selected. Received on Fri May 04 2007 - 11:23:54 CDT