执行计划出现COLLECTION ITERATOR PICKLER FETCH

      今天在使用explain plan for查看 sql执行计划时，出现了如下奇怪的执行计划

1. SQL> explain plan for select * from test where object_id = 100;
   
2. 
   
3. Explained.
   
4. 
   
5. SQL> select * from table(dbms_xplan.display());
   
6. 
   
7. 14 rows selected.
   
8. 
   
9. 
   
10. Execution Plan
    
11. ----------------------------------------------------------
    
12. Plan hash value: 2137789089
    
13. 
    
14. ---------------------------------------------------------------------------------------------
    
15. | Id | Operation             | Name | Rows | Bytes | Cost (%CPU)| Time |
    
16. ---------------------------------------------------------------------------------------------
    
17. | 0 | SELECT STATEMENT         |     | 8168 | 16336 |     29 (0)| 00:00:01 |
    
18. | 1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY | 8168 | 16336 |     29 (0)| 00:00:01 |
    
19. ---------------------------------------------------------------------------------------------
    
20. 
    
21. 
    
22. Statistics
    
23. ----------------------------------------------------------
    
24.      14 recursive calls
    
25.      12 db block gets
    
26.      55 consistent gets
    
27.      0 physical reads
    
28.      0 redo size
    
29.        1414 bytes sent via SQL*Net to client
    
30.     519 bytes received via SQL*Net from client
    
31.      2 SQL*Net roundtrips to/from client
    
32.      1 sorts (memory)
    
33.      0 sorts (disk)
    
34.      14 rows processed

      经过排查，发现是在使用explain plan for之前执行过set autotrace on，关闭autotrace后执行计划就显示正常，一点小知识，记录以供参考。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29821678/viewspace-1450562/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29821678/viewspace-1450562/