Step 2: Create a Batch Baselining Procedure
CREATE OR REPLACE PROCEDURE baseline_all_tracked_sql IS
BEGIN
FOR r IN (SELECT sql_id FROM tracked_sql_ids) LOOP
BEGIN
log_sql_baseline(r.sql_id);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error logging ' || r.sql_id || ': ' || SQLERRM);
END;
END LOOP;
END;
This wraps your log_sql_baseline procedure and runs it for each tracked SQL_ID.