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
