My Oracle Support Banner

[OMC]: The "Storage Usage By Tablespace" Metric does not Consider "Auto-Extended" and "Max Data Allocation" to Calculate "Tablespace Utilization (%)" but Consider "Current Allocation" (Doc ID 2566704.1)

Last updated on JULY 17, 2019

Applies to:

Oracle Management Cloud - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

The "Storage Usage By Tablespace" Metric calculates the value based on the below formula and generates the value:

Used Tablespace (0.86 GB)
----------------------------------    =   95.09%
Current Allocation (0.91 GB)

The Tablespace is Auto-Extended to Max Data Allocation 32 GB, and so the correct formula should be:

Used Tablespace (0.86 GB)
------------------------------------    = 2.70%
Total Space Allocation (32 GB)

The Metric "Storage Usage By Tablespace" is not considering "Total Space Allocation" value but instead taking "Current Allocation", so the result is 95.09% instead of 2.70%.

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

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