Database Administration (MOSC)

MOSC Banner

Baseline ignoring AUTO_CAPTURE_PARSING_SCHEMA filter

Hello

we have a 19c EE database and we enabled the auto capture of the baselines

We used


EXEC DBMS_SPM.CONFIGURE('AUTO_CAPTURE_PARSING_SCHEMA_NAME','APPUSER1',true);

EXEC DBMS_SPM.CONFIGURE('AUTO_CAPTURE_PARSING_SCHEMA_NAME','APPUSER2',true);

so that only the SQLs from these schemas should be considered for creating baselines

But

When we issued the following query

select parsing_schema_name,count(*) from dba_sql_plan_baselines group by parsing_schema_name

we are seeing other schemas as well and also SYS and DBSNMP

PARSING_SCHEMA_NAME       COUNT(*)

------------------------------ ----------

APPUSER1                  404

APPUSER2               11

DBSNMP                 29

SYS                   1

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