> set termout on
> set feedback off
> select * from table(dbms_xplan.display_cursor('&sql_id',&child_number,'ALLSTATS LAST ADVANCED MEMSTATS PARTITION'))
alt:select * from table(dbms_xplan.display_cursor('&sql_id',&child_number,'ALLSTATS LAST ADVANCED MEMSTATS PARTITION'))
neu:select * from table(dbms_xplan.display_cursor('atz8s3n57vk71',0,'ALLSTATS LAST ADVANCED MEMSTATS PARTITION'))
SQL_ID  atz8s3n57vk71, child number 0                                                                                                                                                                                                                                                                       
-------------------------------------                                                                                                                                                                                                                                                                       
select /*+ gather_plan_statistics */  /* '%LOOK_AT_ME%' */  * from dual                                                                                                                                                                                                                                     
                                                                                                                                                                                                                                                                                                            
Plan hash value: 272002086                                                                                                                                                                                                                                                                                  
                                              COMPARE THE E-(Estimated) and A-(Actual)
                                              COMPARE THE E-(Estimated) and A-(Actual)
                                              COMPARE THE E-(Estimated) and A-(Actual)                                                                                                                                                                                                                                                                                                
-----------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                               
| Id  | Operation         | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time   | A-Rows |   A-Time   | Buffers | Reads  |                                                                                                                                                                               
-----------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                               
|   0 | SELECT STATEMENT  |      |      1 |        |       |     2 (100)|          |      1 |00:00:00.01 |       2 |      2 |                                                                                                                                                                               
|   1 |  TABLE ACCESS FULL| DUAL |      1 |      1 |     2 |     2   (0)| 00:00:01 |      1 |00:00:00.01 |       2 |      2 |                                                                                                                                                                               
-----------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                            
Query Block Name / Object Alias (identified by operation id):                                                                                                                                                                                                                                               
-------------------------------------------------------------                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                            
1 - SEL$1 / DUAL@SEL$1                                                                                                                                                                                                                                                                                      
                                                                                                                                                                                                                                                                                                            
Outline Data                                                                                                                                                                                                                                                                                                
-------------                                                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                            
/*+                                                                                                                                                                                                                                                                                                         
BEGIN_OUTLINE_DATA                                                                                                                                                                                                                                                                                          
IGNORE_OPTIM_EMBEDDED_HINTS                                                                                                                                                                                                                                                                                 
OPTIMIZER_FEATURES_ENABLE('11.2.0.2')                                                                                                                                                                                                                                                                       
DB_VERSION('11.2.0.2')                                                                                                                                                                                                                                                                                      
ALL_ROWS                                                                                                                                                                                                                                                                                                    
OUTLINE_LEAF(@"SEL$1")                                                                                                                                                                                                                                                                                      
FULL(@"SEL$1" "DUAL"@"SEL$1")                                                                                                                                                                                                                                                                               
END_OUTLINE_DATA                                                                                                                                                                                                                                                                                            
*/                                                                                                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                                                            
Column Projection Information (identified by operation id):                                                                                                                                                                                                                                                 
-----------------------------------------------------------                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                            
1 - "DUAL"."DUMMY"[VARCHAR2,1]                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                            

> set feedback on
alt:prompt   exec dbms_outln.create_outline(&sql_hash, 0, 'TEST')
neu:prompt   exec dbms_outln.create_outline(176015585, 0, 'TEST')
exec dbms_outln.create_outline(176015585, 0, 'TEST')
> set verify on