在使用select * from table(dbms_xplan.display_cursor(null,null,'advanced'));总是报
1 SQL_ID 9m7787camwh4m, child number 0
2
3 begin :id := sys.dbms_transaction.local_transaction_id; end;
4
5 NOTE: cannot fetch plan for SQL_ID: 9m7787camwh4m, CHILD_NUMBER: 0
6       Please verify value of SQL_ID and CHILD_NUMBER;
7       It could also be that the plan is no longer in cursor cache (check v$sql_plan)
8
这个错误
最终的网上找到解决办法
The error is due to the SQL*Plus environment variable SERVEROUTPUT is turned on. One of the Prerequisites for running the package is to turn off SERVEROUTPUT.

在sqlplus中把关闭
SQL>set serveroutput off

ITPub博客

dbms_xplan.display_cursor 报错 NOTE: cannot fetch plan for SQL_ID

最新文章