OS: Solaris 10
DB: 10.2.0.3
today encountered such a strange thing, using dbms_xplan.display a SQL execution plan, “Error: cannot fetch last explain plan from plan_table”. At the beginning think Plan_table version is out of date, also did not look carefully, then regenerate Plan_table, just run SQL, or report the same error, so it is not Plan_table version of the problem, will it be the SQL itself?Change SQL: select sysdate from Dual, dbMS_xplan.display to display the correct result, run the SQL in question again, the error still remains. Judging from the above phenomenon, that should be the problem with SQL itself.
analyze the SQL in question, mainly several views, these views are based on db link, db link side of the data version is 9.2.0.8, could this be caused by this reason?Delete the 10G plan_table, run the 9i UTlxplan.sql, and run the statement with the problem just now, dbMS_xplan.display displays the result normally.
there is another method, manually update the plan_id field in the 10G plan_table, set the plan_id in the record to a value, dbms_xplan.display can display the result normally.
From “ITPUB blog” link: http://blog.itpub.net/45188/viewspace-1022784/, if you want to reprint, please indicate the source, otherwise will be investigated for legal responsibility.
Reproduced in: http://blog.itpub.net/45188/viewspace-1022784/
Read More:
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- Hive view execution plan
- PSQLException: ERROR: cached plan must not change result type
- Group by operator of hive execution plan
- 1093 – You can’t specify target table ‘table’ for update in FROM clause
- MySQL advanced — Explanation of ref field in explain information
- Explain MySQL replication error 1032 & 1205
- Explain stdin, stdout, stderr in C language
- Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
- Error 1146 (42s02): table ‘database name. Table name’ doesn’t exist ‘
- (element UI component table) how to add a style to a table
- Errors in IntelliJ ieeasql statements and table names in @ table
- ubuntu executes apt-get update and reports Failed to fetch/replace Ali source
- An error occurred when opensips started the service“ ERROR:core :db_ check_ table_ Version: invalid version 7 for Table dialog found “
- E: Unable to fetch some archives, maybe run apt-get update or try with –fix-missing?
- Browser console prompt: Error: NetworkError when attempting to fetch resource.
- How to solve the problem of “please enter a commit message to explain why this merge is necessary” when git merges branches?
- error: cannot open .git/FETCH_ Head: permission denied resolved
- TypeError: Failed to execute ‘fetch‘ on ‘Window‘: Request with GET/HEAD method cannot have body.