Oracle Database

--
-- Create the Tuning Set
--
 
BEGIN
DBMS_SQLTUNE.CREATE_SQLSET(sqlset_name => 'STS_AWR');
END;
/

--
-- Load the Tuning Set
--
 
  DECLARE
    l_cursor DBMS_SQLTUNE.sqlset_cursor;
  BEGIN
   OPEN l_cursor FOR
   SELECT VALUE(p)
   FROM TABLE (DBMS_SQLTUNE.select_cursor_cache (NULL,NULL,NULL,NULL,NULL,NULL,1)) p;  -- The first two parameters are the Snap IDs.  The last parameter is The top L(imit) SQL from the (filtered) source ranked by the ranking measure.  
                                                                                       -- Details of others can be found here https://docs.oracle.com/database/121/ARPLS/d_sqltun.htm#ARPLS68454
 
   DBMS_SQLTUNE.load_sqlset ( 
     sqlset_name => 'STS_AWR',
     populate_cursor => l_cursor);
  END;
  /