Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, June 02, 2015

12c: ORA-65114: space usage in container is too high

ORA-65114: space usage in container is too high
Cause: Space usage in the current container exceeded the value of MAX_PDB_STORAGE for the container.
Action: Specify a higher value for MAX_PDB_STORAGE using the ALTER PLUGGABLE DATABASE statement.

Test:

SQL> show con_name

CON_NAME
------------------------------
PDB2

SQL> create tablespace pdb2TS1 datafile size 10M;
create tablespace pdb2TS1 datafile size 10M
*
ERROR at line 1:
ORA-65114: space usage in container is too high

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB
------------------------------ ----------
PDB2                                  860


-- Increase the total storage of the the PDB (datafile and local temp files).
SQL> ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 2048M);

Pluggable database altered.

You could use some other options

-- Limit the amount of temp space used in the shared temp files.
ALTER PLUGGABLE DATABASE STORAGE (MAX_SHARED_TEMP_SIZE 1G);

-- Combine the two.
ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 1G);

-- Remove the limits.
ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB
------------------------------ ----------
PDB2                                  860

SQL> create tablespace pdb2TS1 datafile size 10M;

Tablespace created.

SQL> select name, TOTAL_SIZE/1024/1024 SIZE_MB from v$pdbs;

NAME                              SIZE_MB
------------------------------ ----------
PDB2                                  870

No comments: