Database Tuning (MOSC)

MOSC Banner

set autotrace traceonly explain then - 'PLAN_TABLE' is old version

edited Apr 17, 2014 8:44AM in Database Tuning (MOSC) 10 commentsAnswered ✓
Hello gurus,
     I would like analyze several queries because it's seemes i have times response very then when i execute :
     The version of my database is 11.2.0.3 :

     SQL>   set autotrace traceonly explain
     SQL> my query therefore i have :
               Note
               -----
               - 'PLAN_TABLE' is old version

>>>> i tried to execute $ORACLE_HOME/rdbms/admin/catplan.sql
and i executed again and again i have the message above.

My query and the result :

select VENDOR_ID, count(VENDOR_ID), PREPAY_ID, count(PREPAY_ID) FROM AP_UNAPPLY_PREPAYS_FR_PREPAY_V group by VENDOR_ID, PREPAY_ID;

Execution Plan
----------------------------------------------------------

--------------------------------------------------------------------------------------------------------------
| Id  | Operation                                | Name                         | Rows  | Bytes | Cost (%CPU)|

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center