-------------------------------------------------------------------------------                                                             
FINDINGS SECTION (1 finding)                                                                                                                
-------------------------------------------------------------------------------                                                             
                                                                                                                                            
1- Alternative Plan Finding                                                                                                                 
---------------------------                                                                                                                 
  Some alternative execution plans for this statement were found by searching                                                               
  the system's real-time and historical performance data.                                                                                   
                                                                                                                                            
  The following table lists these plans ranked by their average elapsed time.                                                               
  See section "ALTERNATIVE PLANS SECTION" for detailed information on each                                                                  
  plan.                                                                                                                                     
                                                                                                                                            
  id plan hash  last seen            elapsed (s)  origin          note                                                                      
  -- ---------- -------------------- ------------ --------------- ----------------                                                          
   1 2675695437  2021-11-29/08:00:23        8.068 AWR             original plan                                                             
   2 2201765684  2021-12-01/10:36:12      303.150 Cursor Cache                                                                              
                                                                                                                                            
  Information                                                                                                                               
  -----------                                                                                                                               
  - The Original Plan appears to have the best performance, based on the                                                                    
    elapsed time per execution.  However, if you know that one alternative                                                                  
    plan is better than the Original Plan, you can create a SQL plan baseline                                                               
    for it. This will instruct the Oracle optimizer to pick it over any other                                                               
    choices in the future.                                                                                                                  
    execute dbms_sqltune.create_sql_plan_baseline(task_name => 'TASK_265886',                                                               
            owner_name => 'WTOLENTINO', plan_hash_value => xxxxxxxx);  

SQL> execute dbms_sqltune.create_sql_plan_baseline(task_name => 'TASK_265886', owner_name => 'WTOLENTINO', plan_hash_value => '2675695437');

ERROR at line 1:
ORA-13846: Cannot create SQL plan baseline on the given plan
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 19154
ORA-06512: at "SYS.DBMS_SQLTUNE", line 11150
ORA-06512: at line 1