EM 13.4 - Wrong TEMP Tablespace Usage Alerts Being Reported for Multi-tenant Databases (CDB) (Doc ID 2791794.1)

Last updated on JANUARY 18, 2023

Applies to:

Symptoms

EM 13.4, Monitoring 12.2 CDB reports following wrong temp tablespace usage alert:

Host=<hostname>
Target type=Pluggable Database
Target name=<target db name>_CDBROOT
Categories=Capacity
Message=Tablespace [TEMP] is [96.4 percent] full
Severity=Critical
Event reported time=Jul 5, 2021 7:18:19 AM EDT
Line of Business=<LOB>
Operating System=Linux
Platform=x86_64
Associated Incident Id=87746
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=problemTbspTemp:pctUsed
Metric Group=Tablespaces Full (Temp)
Metric=Tablespace Space Used (%) (Temp)
Metric value=96.4
Key Value=TEMP
Key Column 1=Tablespace Name
Rule Name=<Rule Name>
Rule Owner=<Rule Owner>
Update Details:
Tablespace [TEMP] is [96.4 percent] full
Incident created by rule (Name = Incident management rule set for all targets, Create incident for critical metric alerts [System generated rule]).

Changes

Cause

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