My Oracle Support Banner

EM13c : Non-System Data Segments in System Tablespaces CS Rule reporting violation (Doc ID 2828756.1)

Last updated on DECEMBER 16, 2021

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


In Enterprise Manager (EM) Cloud Control, The "Non-System Data Segments in System Tablespaces" Compliance Standard Rules in OEM 13c is reporting a violation because of segments belonging to "DBSFWUSER", which is a system user.

Here is how that rule is enforced.

1) The agent running on the database node uses the OEM Database plugin to collect the information.

It uses the "$AGENT_HOME/plugins/oracle.sysman.db.agent.plugin_13." script to do that.

2) The information collected by the agent is pushed to the OEM repository.

3) The compliance rule uses the view MGMT$CS_DB_REC_SEG_COUNT to decide if there is a violation.

So here is why the rule reports a false violation related to segments belonging to user "DBSFWUSER".

The query used to collect the information is located in the script

"$AGENT_HOME/plugins/oracle.sysman.db.agent.plugin_13." and it excludes the following users :





You will notice that this exclusion list does not include "DBSFWUSER".

So even if the user "DBSFWUSER" is a "SYSTEM" users that uses the "SYSAUX" tablespace, it should not raise a violation of compliance and it does.

And we can confirm that The "DBSFWUSER" is identified as system user because the column ORACLE_MAINTAINED is set to "Y" in DBA_USERS.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.