SPM - DBMS_SPM.CONFIGURE - Filter not working as expected
Hi
We have a 19c database (19.8) with optimizer_features_enable set to 12.2 (for now )
We are trying to enable auto capture of baseline but we wanted to capture the baseline only for specific schemas
So here is what we did
EXEC DBMS_SPM.CONFIGURE('AUTO_CAPTURE_PARSING_SCHEMA_NAME','APP1',true);
EXEC DBMS_SPM.CONFIGURE('AUTO_CAPTURE_PARSING_SCHEMA_NAME','RTP1',true);
EXEC DBMS_SPM.CONFIGURE('AUTO_CAPTURE_PARSING_SCHEMA_NAME','BATCH1',true);
and we confirmed it
select parameter_name,parameter_value from dba_sql_management_config where parameter_name='AUTO_CAPTURE_PARSING_SCHEMA_NAME';
PARAMETER_NAME PARAMETER_VALUE