explain plan - cheeyoung/sqlplus-public GitHub Wiki

• PLAN_TABLE table in UTLXPLAN.SQL script

Error and Notification messages

• ORA-600 [KGL-heap-size-exceeded] error when trying to run specific EXPLAIN PLAN FOR statement that is very long and has long list in select lists and UNPIVOT
• Heap size 1007188K exceeds notification threshold (97656K)

   563  Tue Mar 06 19:34:29 2018
   564  Memory Notification: Library Cache Object loaded into SGA
   565  Heap size 1007188K exceeds notification threshold (97656K)
   566  Details in trace file /.../.../diag/rdbms/test/TEST/trace/TEST_ora_5114.trc
   567  Tue Mar 06 19:34:29 2018
   568  KGL object name :explain plan for
   569  WITH WEEK_DATA AS(

References

EXPLAIN PLAN statement