My Oracle Support Banner

EM 13.5c: OEM Does Not Send 'Tablespace Space Used (%)' Alerts If The Datafiles Have Autoextend Enabled (Doc ID 2986570.1)

Last updated on NOVEMBER 17, 2023

Applies to:

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

Symptoms

Enterprise Manager Cloud Control (OEM), did not send any alert from database 'Tablespace Space Used (%)' metric when the tablespace usage has crossed the set thresholds on many tablespaces.

The database alert log shows following entries when tablespace was full and autoextended.

Thu Nov 02 14:01:19 2023
ALTER TABLESPACE <Tablespace Name> ADD DATAFILE SIZE 30G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE <Tablespace Name> ADD DATAFILE SIZE 30G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
ALTER TABLESPACE <Tablespace Name> ADD DATAFILE SIZE 30G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE <Tablespace Name> ADD DATAFILE SIZE 30G AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
Thu Nov 02 14:01:35 2023
Thread 1 advanced to log sequence 288780 (LGWR switch)
Current log# 19 seq# 288780 mem# 0: <path>/group_19.694.1119747285
Thu Nov 02 14:01:35 2023
TT01: Standby redo logfile selected for thread 1 sequence 288780 for destination LOG_ARCHIVE_DEST_4

At the same time, crontab job has sent the alert. But the OEM console shows the highest collected value much lesser than the set thresholds and no alert was sent from OEM.

Cause

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
Symptoms
Cause
Solution
References


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