
Index created.

Elapsed: 00:00:01.33

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.18

PL/SQL procedure successfully completed.

Elapsed: 00:00:02.55

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.58

                                                                                                                                                                                                        
                                                                                                                                                                                                        

1 row selected.

Elapsed: 00:00:00.20
old   6:          '&&good_sql_id' as sql_id,
new   6:          'dmqkpmc08m1jv' as sql_id,
old   7:          to_number('&&good_plan_hash') as plan_hash_value,
new   7:          to_number('3093251051') as plan_hash_value,
old   8:          to_number('&&good_executions') as executions,
new   8:          to_number('        75') as executions,

1 row merged.

Elapsed: 00:00:00.00

Commit complete.

Elapsed: 00:00:00.00

=== Captured improved execution ===

BEGIN_SNAP                                                                                                                                                                                              
----------                                                                                                                                                                                              
         5                                                                                                                                                                                              


  END_SNAP                                                                                                                                                                                              
----------                                                                                                                                                                                              
         6                                                                                                                                                                                              


RESULT_COUNT                                                                                                                                                                                            
------------                                                                                                                                                                                            
          48                                                                                                                                                                                            


ELAPSED_HSECS                                                                                                                                                                                           
-------------                                                                                                                                                                                           
            2                                                                                                                                                                                           


RUN_LABEL                      BEGIN_SNAP   END_SNAP SQL_ID        PLAN_HASH_VALUE EXECUTIONS ELAPSED_SECONDS RECORDED_AT                                                                               
------------------------------ ---------- ---------- ------------- --------------- ---------- --------------- ---------------------------------------------------------------------------               
GOOD                                    5          6 dmqkpmc08m1jv      3093251051         75             .02 04-AUG-26 03.36.34.260000 AM                                                              

1 row selected.

Elapsed: 00:00:00.00
