create baselines for all sqls of a schema - Oracle Database Script. DECLARE nRet NUMBER; BEGIN nRet := dbms_spm.load_plans_from_cursor_cache(attribute_name => 'PARSING_SCHEMA_NAME', attribute_value => '&schema_name'); END;
DECLARE nRet NUMBER; BEGIN nRet := dbms_spm.load_plans_from_cursor_cache(attribute_name => 'PARSING_SCHEMA_NAME', attribute_value => '&schema_name'); END;