On May 4, 12:53 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Ben" <bal..._at_comcast.net> a écrit dans le message de news: 1178295834.160371.234..._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
LOL it's amazing what you get when you are working with the correct
tools.
I really thought I had already dropped and re-created this table with
the new script. Upon further review I find that the two columns for
access and filter predicates do not exist.
simply put, thanks.
Received on Fri May 04 2007 - 12:55:20 CDT
