cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, CHILD_NUMBER: 0
来源:互联网 发布:ppt软件官方下载 编辑:程序博客网 时间:2024/05/27 20:50
SQL> set serveroutput off --一定要关
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 5qgz1p0cut7mx, child number 0
BEGIN DBMS_OUTPUT.DISABLE; END;
NOTE: cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, 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)
已选择8行。
SQL> select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 7xdg8akqchn1t, child number 1
-------------------------------------
select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'))
Plan hash value: 3713220770
---------------------------------------------------------------------
| Id | Operation | Name | E-Rows |
---------------------------------------------------------------------
| 0 | SELECT STATEMENT | | |
| 1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY_CURSOR | 16 |
---------------------------------------------------------------------
Note
-----
- cardinality feedback used for this statement
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
已选择20行。
SQL> select count(*) from t1 where object_id between :x and :y;
COUNT(*)
----------
145152
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 1ynfbm8a0p98u, child number 0
-------------------------------------
select count(*) from t1 where object_id between :x and :y
Plan hash value: 1410530761
---------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 91 (100)| |
| 1 | SORT AGGREGATE | | 1 | 5 | | |
|* 2 | FILTER | | | | | |
|* 3 | INDEX FAST FULL SCAN| IDX_T1 | 145K| 708K| 91 (3)| 00:00:02 |
---------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
3 - SEL$1 / T1@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX_FFS(@"SEL$1" "T1"@"SEL$1" ("T1"."OBJECT_ID"))
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :X (NUMBER): 0
2 - :Y (NUMBER): 100000
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter(:X<=:Y)
3 - filter(("OBJECT_ID">=:X AND "OBJECT_ID"<=:Y))
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=0) COUNT(*)[22]
已选择52行。
0 0
- cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, CHILD_NUMBER: 0
- NOTE: cannot fetch plan for SQL_ID: ******, CHILD_NUMBER: 0
- cannot fetch plan for SQL_ID
- ORACLE cannot fetch plan for SQL_ID
- NOTE: cannot fetch plan for SQL_ID:
- Error: cannot fetch plan for statement_id 'PLUS22048358'
- Plan for the day
- Plan for this week
- a plan for fun
- EXPLAIN PLAN FOR
- plan for aphinier
- cannot simultaneously fetch multiple bags
- cannot simultaneously fetch multiple bags
- cannot simultaneously fetch multiple bags
- cannot simultaneously fetch multiple bags
- Plan for the next week
- a plan for 2012--2013
- Plan for Perl Web Development
- test2
- CC2530低功耗终端不停重连网络耗电问题
- 用u盘恢复路由器的ios
- 某裤子txt格式转存到MySQL
- 揭秘喜马拉雅黑科技——网页播放器(创建自己的单页应用)
- cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, CHILD_NUMBER: 0
- Request介绍及示例 PART1
- Service
- linux命令dd
- QQ8.2 自动掉线完美解决
- Hibernate学习总结:OneToMany单向关联
- 什么是jvm?
- Zero-Copy&sendfile浅析
- Iocomp控件教程之LinearGauge--线性刻度尺控件