My Oracle Support Banner

EM13c : "AddSpacetoTablespace" CA not increasing the MAXSIZE for SMALLFILE tablespaces (Doc ID 2566948.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, Using the "Add Space to Tablespace" Corrective Action (CA) for a database. Noticed the CA took care of the tablespace alert for
the tablespace by adding space.

However, the datafile was resized to ~2.18 GB even though the max size of this datafile is set to 2 GB. We expected the max size of the respective datafile to be increased.

BEFORE Corrective Action:

select file_name,bytes/(1024*1024*1024),maxbytes/(1024*1024*1024) from dba_data_files where tablespace_name='TEST_DATA';


FILE_NAME                                                                    BYTES/(1024*1024*1024)       MAXBYTES/(1024*1024*1024)
----------------------------------------------------------------------------------- -------------------------------------------------------------
+DATA/VATTAX_D/DATAFILE/test_data.278.989594469                         2                                           2
+DATA/VATTAX_D/DATAFILE/test_data.279.989594483                  1.80664063                                   2

TABLESPACE_NAME             USED_SPACE          TABLESPACE_SIZE                  USED_PERCENT
------------------------------ ---------- --------------- ------------------- ------------------- ------------
TEST_DATA                         3.75195313                    4                                93.7988281

 

AFTER Corrective Action:

select file_name,bytes/(1024*1024*1024),maxbytes/(1024*1024*1024) from dba_data_files where tablespace_name='TEST_DATA';

 

FILE_NAME                                                                      BYTES/(1024*1024*1024)       MAXBYTES/(1024*1024*1024)
----------------------------------------------------------------------------------- -------------------------------------------------------------
+DATA/VATTAX_D/DATAFILE/test_data.278.989594469                           2                                         2
+DATA/VATTAX_D/DATAFILE/test_data.279.989594483                      2.1875                                      2

TABLESPACE_NAME             USED_SPACE           TABLESPACE_SIZE                  USED_PERCENT
------------------------------ ---------- --------------- ---------------------- --------------- ---------------
TEST_DATA                          3.75195313                4.1875                            89.5988806

 

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.