Resolve the execution plan does not see an issue with the ' plan_table ' is-old version of the filter condition

Resolve ' plan_table ' is old version

When you parse the SQL execution plan, you encounter
' Plan_table ' is old version
Think of it, the database is upgraded from a lower version, which is estimated to be the reason

Workaround: Remove plan_table rebuild

Sql>explain plan for SELECT * from users;

explained.

Sql>select * FROM table (dbms_xplan.display);

Plan_table_output
--------------------------------------------------------------------------------

-----------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-----------------------------------------------------------
| 0 | SELECT STATEMENT | | 455 | 19565 | 4 |
| 1 | TABLE ACCESS full| USERS | 455 | 19565 | 4 |
-----------------------------------------------------------

Note
-----
-' plan_table ' is old version

One by one rows selected.

sql> drop table plan_table purge;

Table dropped.

Sql> @/home/ora10g/product/10.2.0/rdbms/admin/utlxplan.sql

Table created.
Sql>explain plan for SELECT * from users;

explained.

Sql>select * FROM table (dbms_xplan.display);

Plan_table_output
--------------------------------------------------------------------------------
Plan Hash value:3461732445

---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2406 | 86616 | 4 (0) | 00:00:01 |
| 1 | TABLE ACCESS full| USERS | 2406 | 86616 | 4 (0) | 00:00:01 |
---------------------------------------------------------------------------

8 rows selected.

In contrast, the contents of the display are different.

[@[email protected]]

Resolve the execution plan does not see an issue with the ' plan_table ' is-old version of the filter condition