My Oracle Support Banner

Incorrect Tablespace Alerts Generated for BYTES_FREE Metric. (Doc ID 1676260.1)

Last updated on JANUARY 02, 2020

Applies to:

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



Incorrect tablespace alerts are generated for BYTES_FREE metric in dba_outstanding_alerts. Sometime, Warning or Critical alerts are generated for Free tablespace. Sometimes, Critical alerts are generated instead of warning etc.

Create a new tablespace:

The alert is raised even though the tablespace is empty.


Another scenario will be:

Tablespace Bytes Space Usage LE 8192 LE 5120
=> warning less then 8Mb critical less then 5Mb .

But the alert raised is:

------------ ------------ -------------
Tablespace [TEST1] only has [7 megabytes] free space
7 Warning 1
05-FEB-13 AM -08:00

=> ie, a critical alert is raised while 1st a warning should be raised for less then 8Mb. 

Or in other words, a warning alert is skipped and critical alert is raised for tablespace.


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.