My Oracle Support Banner

TOTAL_SIZE In V$PDBs Smaller Than Actual Size Of Pluggable Database (Doc ID 2197261.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

In v$pdbs the total_size column is not increasing after resizing the datafile of pluggable database.

Changes

SQL> show con_name

CON_NAME
------------------------------
PDB2
SQL> select name , bytes/(1024*1024) from v$datafile;

NAME BYTES/(1024*1024)
---------------------------------------- -----------------
+SCHE1/db1_undo1.f 1208
+SCHE1/pdb2-db1_system.f 304.9375
+SCHE1/pdb2-db1_sysaux.f 206.1875
+SCHE1/db1_aq-pdb2.f 2000
+SCHE1/pdb2-db1_hari.f 1000

SQL> select name,open_mode ,total_size/(1024*1024) from v$pdbs where con_id=4;

NAME OPEN_MODE TOTAL_SIZE/(1024*1024)
------------------------------ ---------- ----------------------
PDB2 READ WRITE 1650

SQL> create tablespace test datafile '+SCHE1/pdb2-db1-test.f' size 1000m;

Tablespace created.

SQL> select name , bytes/(1024*1024) from v$datafile;

NAME BYTES/(1024*1024)
---------------------------------------- -----------------
+SCHE1/db1_undo1.f 1208
+SCHE1/pdb2-db1_system.f 304.9375
+SCHE1/pdb2-db1_sysaux.f 206.1875
+SCHE1/db1_aq-pdb2.f 2000
+SCHE1/pdb2-db1_hari.f 1000
+SCHE1/pdb2-db1-test.f 1000

6 rows selected.

SQL> select name,open_mode ,total_size/(1024*1024) from v$pdbs where con_id=4;

NAME OPEN_MODE TOTAL_SIZE/(1024*1024)
------------------------------ ---------- ----------------------
PDB2 READ WRITE 2650 <<<---- Current value

SQL> alter database datafile '+SCHE1/pdb2-db1-test.f' resize 3000m;

Database altered.

SQL> select name , bytes/(1024*1024) from v$datafile;

NAME BYTES/(1024*1024)
---------------------------------------- -----------------
+SCHE1/db1_undo1.f 1208
+SCHE1/pdb2-db1_system.f 304.9375
+SCHE1/pdb2-db1_sysaux.f 206.1875
+SCHE1/db1_aq-pdb2.f 2000
+SCHE1/pdb2-db1_hari.f 1000
+SCHE1/pdb2-db1-test.f 3000

6 rows selected.

SQL> select file_name,bytes/(1024*1024) from cdb_data_files where con_id=4;

FILE_NAME BYTES/(1024*1024)
---------------------------------------- -----------------
+SCHE1/pdb2-db1_system.f 312.9375
+SCHE1/pdb2-db1_sysaux.f 206.1875
+SCHE1/db1_aq-pdb2.f 2000
+SCHE1/pdb2-db1_hari.f 1000
+SCHE1/pdb2-db1-test.f 3000

SQL> select name,open_mode ,total_size/(1024*1024) from v$pdbs where con_id=4;

NAME OPEN_MODE TOTAL_SIZE/(1024*1024)
------------------------------ ---------- ----------------------
PDB2 READ WRITE 2650 <<<---- This remains the same.

 

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
Changes
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.