My Oracle Support Banner

EM 12c, EM 13c: How to Increase the size of a Tablespace using Enterprise Manager Cloud Control (Doc ID 1929325.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and later
Information in this document applies to any platform.
Metric alert for Database Instance "Tablespace Space Used (%)" in Enterprise Manager 12c
Metric alert for Cluster Database "Tablespace Space Used (%)" in Enterprise Manager 12c

Goal

To increase the size of a tablespace using Enterprise Manager Cloud Control.

Enterprise Manager can be configured to send a notification when the size of a tablespace crosses a user specified threshold.  By default a 'warning' alert is generated at 85% and a critical at 97%, but these thresholds can be edited appropriately by the Enterprise Manager user.  When a tablespace crosses the specified threshold an event will be generated in 'incident manager'.  Either in "events without incidents" (for a warning), or in "all open incidents" for a critical (if using the default Oracle provided incident rule).  The accompanying text will be:-

Tablespace <tablespace name> is <n> percent full

This article discusses the action to take when the tablespace is genuinely full and needs more space.

If the metric has been raised erroneously see:

<Note:1928592.1> "Understanding the role of the Server Generated Alert System in the evaluation of the Tablespace Space Full (%) metric in Enterprise Manager 12c"

Solution

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
Goal
 To increase the size of a tablespace using Enterprise Manager Cloud Control.
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.