Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center