when we try to explan plan, we get the below error, this is becauae the plan table is corrupted
drop and recreate the plan table.
SQL> explain plan for select * from id_meta_ticket_query;
Explained.
drop and recreate the plan table.
SQL> explain plan for select * from id_meta_ticket_query;
Explained.
SQL> SELECT * FROM TABLE(dbms_xplan.display);
PLAN_TABLE_OUTPUT
------------------------------------------------------
ERROR: an uncaught error in function display has happe Please provide also a DMP file of the used plan
ORA-00904: "OTHER_TAG": invalid identifier
SQL> drop table plan_table;
Table dropped.
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql
Table created.
SQL> explain plan for select * from id_meta_ticket_query;
Explained.
SQL> select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------
Plan hash value: 683485703
------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 867 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| ID_META_TICKET_QUERY | 1 | 867 | 2 (0)| 00:00:01 |
------------------------------------------------------------------------------------------
8 rows selected.
