如何获取执行计划(三)

2014-11-24 07:39:14 · 作者: · 浏览: 17
UT.GET_LINES(:LINES, :NUMLINES); END; --也无法获取真实的执行计划 NOTE: cannot fetch plan for SQL_ID: 9babjv8yq8ru3, CHILD_NUMBER: 0 Please verify value of SQL_ID and CHILD_NUMBER; It could also be that the plan is no longer in cursor cache (check v$sql_plan)