select * from table(dbms_xplan.display);
select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------
ERROR: cannot get definition for table 'PLAN_TABLE'
ORA-00980: synonym translation is no longer valid
怎么解决?
------解决方案--------------------SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
---------------------------------------------
Plan hash value: 1357081020
--------------------------------------
------解决方案-------------------- Id
------解决方案-------------------- Operation
------解决方案-------------------- Name
------解决方案-------------------- Rows
------解决方案-------------------- Bytes
------解决方案-------------------- Cost (%CPU)
------解决方案-------------------- Time
------解决方案--------------------
--------------------------------------
------解决方案-------------------- 0
------解决方案-------------------- SELECT STATEMENT
------解决方案-------------------- ------解决方案-------------------- 7
------解决方案--------------------