SP2-0613: Unable to verify PLAN_TABLE format or existence SP2-0611: Error enabling EXPLAIN report


sqlplus / as sysdba

SQL> set autotrace traceonly

SP2-0613: Unable to verify PLAN_TABLE format or existence
SP2-0611: Error enabling EXPLAIN report

Hopssssss what is problem!!!!

$ ORACLE_HOME / RDBMS / admin folder by running utlxplan.sql  I can create the table automatically.

Solution:

SQL> @utlxplan.sql 

Table created.

AUTOTRACE not result in an error.

SQL> set autotrace traceonly

Good !

For example:

 

SQL> insert into deneme1 select * from v$archived_log;

4237 rows created.

Execution Plan
———————————————————-
0 INSERT STATEMENT Optimizer=CHOOSE
1 0 FIXED TABLE (FULL) OF ‘X$KCCAL’

Statistics
———————————————————-
87 recursive calls
653 db block gets
242 consistent gets
0 physical reads
877196 redo size
793 bytes sent via SQL*Net to client
697 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
4237 rows processed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: