Oracle execution plan prompt 'Plan _ table' is old version Solution

When you use set autotrace or explain Plan for to generate an execution plan, the following message is displayed:

Note

-----
-'Plan _ table' is old version

 

The cause of this error is that the execution plan of Toad has been analyzed. Therefore, plan_table is generated by executing its own script.

 

Solution: Drop plan_table and recreate it.

SQL> drop table plan_table;

Table dropped.

 

SQL> @? /Rdbms/admin/utlxplan. SQL

 

 

Explain the Oracle execution plan

Http://blog.csdn.net/tianlesoftware/article/details/5827245

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Email: tianlesoftware@gmail.com

Skype: tianlesoftware

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 (full) dba5 group: 142216823 (full)

Dba6 group: 158654907 (full) dba7 group: 172855474 dba8 group: 102954821