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

在使用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博客 ” ，链接：http://blog.itpub.net/12798004/viewspace-1480971/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12798004/viewspace-1480971/