Fetch the SQL BASELINE evolve Report without actually change the ACCEPTED flag

In this blog we will explain the details of how to fetch the SQL BASELINE Report.

first of the the method we use for SQL PLAN BASELINE is the EVOLVE and the feature name used in Oracle is SQL PLAN MANAGER.  Oracle has provided the DBMS package for this is SPM. 

Now in the SPM Package ,we evolve the SQL PLAN BASELINE manually. Once we run the evolve this will evaluate the benefit of SQL PLAN BASELINE plans and accept them. Once we do not need to make changes and only to fetch the report of the SQLPLAB BASELINE, the cause COMMIT=NO is used. 

Sample example - 

set lines 200 pages 20000

set serveroutput on
  declare evolve_out CLOB;
  begin
  evolve_out := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE ( SQL_HANDLE => 'SQL_abdfaaa7e926cf0a', 

  COMMIT => 'NO' );
  dbms_output.put_line(evolve_out);
  end; 

/