Oracle Error Cannot Fetch Last Explain Plan From Plan_table
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help error cannot fetch plan for statement_id autotrace Receive Real-Time Help Create a Freelance Project Hire for a Full
Create Plan Table
Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error: cannot fetch last explain plan from PLAN_TABLE Want to Advertise Here? Solved Error: cannot fetch last explain plan from PLAN_TABLE Posted on 2015-12-10 Oracle Database 1 Verified Solution 2 Comments 1,197 Views Last Modified: 2015-12-10 When running the highlighted / second query I'm receiving the below error message. Can anyone help to resolve? 0 Question by:Jim Horn Facebook Twitter LinkedIn Google LVL 76 Active today Best Solution byslightwv (䄆 Netminder) You commented out the "explain plan" piece. I had it on two lines so it might have been confusing... it was actually part of what you needed to execute. This is the actual statement to execute: Go to Solution 2 Comments LVL 76 Overall: Level 76 Oracle Database 74 Message Active today Accepted Solution by:slightwv (䄆 Netminder)2015-12-10 You commented out the "explain plan" piece. I had it on two lines so it might have been confusing... it was actually part of what you needed to execute. This is the actual statement to execute: explain plan for Select * from tab1 join tab2 using (col1); 0 LVL 65 Overall: Level 65 Oracle Database 3 Message Active today Author Comment by:Jim Horn2015-12-10 Got it. For some odd reason I thought that was a comment, and commented it out. Now I'm getting the below, where the two query result tabs are identical. Thanks. Jim 0 Write Comment First Name Please enter a first
首页 | 博文目录 | 关于我 pingshx 博客访问: 112708 博文数量: 45 用 户 组: 普通用户 注册时间: 1970-01-01 08:00 个人简介 鏆傛棤浠嬬粛 文章分类 全部博文(45) 一般分类(4) Oracle(35) Perl(3) OS(Unix,Linux)(1) DB2(2) 未分配的博文(0) https://www.experts-exchange.com/questions/28897774/Error-cannot-fetch-last-explain-plan-from-PLAN-TABLE.html 文章存档 2010年(12) 2010年05月(1) 2010年04月(4) 2010年03月(2) 2010年02月(1) 2010年01月(4) 2009年(33) 2009年12月(2) 2009年11月(3) 2009年10月(1) 2009年09月(4) 2009年08月(5) 2009年07月(4) 2009年06月(5) 2009年05月(9) 我的朋友 最近访客 stilllov junyangt zhangxd_ urlgaoji http://blog.itpub.net/45188/viewspace-1022784/ invt_dav sohuyaho jianlian 20061805 tntpro 微信关注 IT168企业级官微 微信号:IT168qiye 系统架构师大会 微信号:SACC2013 订阅 推荐博文 ·Table ·Windows Server 2008完美安装... ·mysqlimport导入报错的排查... ·mysql数据库性能诊断 ·Oracle 12c Data Guard搭建(... 热词专题 Error: cannot fetch last explain plan from plan_table 2009-06-04 13:59:13 分类: Oracle
环境:OS: Solaris 10DB: 10.2.0.3今天碰到这样的怪事,用dbms_xplan.display显示一条SQL执行计划时,报错"Error: cannot fetch last explain plan from plan_table". 一开始就觉得Plan_table的版本是不是过时了,也没仔细看,就重新生成plan_table,再跑刚条SQL,还是报一样的错误,这样看来,就不是Plan_table版本的问题了,那会不会是SQL本身的问题呢?换一条SQL:select sysdate from dual,通过dbms_xplan.display正确显示结果,再跑一下有问题的那SQL,错误依旧。从上面的现象来判断,那应是SQL本身的问题。分析一下出问题的SQL,主要是几张视图,这几张视图都是基于db link的,db link一边的数据版本是9.2.0.8的,会不会是这因为这个原因造成的?删除10G的plan_table,跑一下9i的utlxplan.sql,再跑一下刚才有问题的语句,dbms_xplan.display正常显示结果了。还有一方法,手动update 10G plan_table里的plan_id字段,把记录里plan_id都设置成一个数值,dbms_xplan.display能正常显示结果.[@more@] 阅读(3938) | 评论(0) | 转发(0) | 1ر С crm ORACLE Ŀϵͳ thread error cannot android python java û Ǹָⲻڻѱɾڱ TOPְ ְ ־ Ŷ ͳ ϲ ֪ʶ Ƶ ־ error cannot fetch ıģʽ ITPUBҳ | ITPUB̳ | ݿ⼼ | ҵϢ | | | Ŀ | IBM | ҵ | ITƸ | ITĵ | IT ChinaUnix | ChinaUnix | ChinaUnix̳ | SAP ERPϵͳ CopyRight 1999-2011 itpub.net All Right Reserved. 𩳽Ϣ˾ȨСϵǡվʦ˽ߡ֪ʶȨ ICP֤:060528šйֺ־ıţ1101082001㲥ӽĿӪ֤ţֵ1149 ض