Re: How to see Predicates in xplan display?

"Ben" <balvey_at_comcast.net> a écrit dans le message de news: 1178295834.160371.234770_at_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
| -------------------------------------------------------------------------------
|
| ----------------------------------------------------------------------------
|| Id | Operation | Name | Rows | Bytes |
| Cost |
| ----------------------------------------------------------------------------
|| 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.
|

Drop your OLD plan_table and recreate it with your current version script ($ORACLE_HOME/rdbms/admin/utlxplan.sql)

Regards
Michel Cadot Received on Fri May 04 2007 - 11:53:37 CDT