My Oracle Support Banner

Adding datafile to the tablespace does not reflect in cdb_tablespace_usage_metrics or dba_tablespace_usage_metrics view. (Doc ID 2780297.1)

Last updated on MAY 28, 2021

Applies to:

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

Symptoms

Adding data file to tablespace does not reflect in cdb_tablespace_usage_metrics and dba_tablespace_usage_metrics view.

After adding data file to tablespace CDB_TABLESPACE_USAGE_METRICS is not showing correct result:

SQL> select * from cdb_tablespace_usage_metrics;

TABLESPACE_NAME                USED_SPACE TABLESPACE_SIZE USED_PERCENT    CON_ID
------------------------------ ---------- --------------- ------------ ----------
....
<tablespace>                      4189366         4194302   99.8823165          3
.....
16 rows selected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 <pdb>                          READ WRITE NO
SQL>  alter session set container=<pdb>;

Session altered.

SQL> alter tablespace <tablespace> add datafile size 10g autoextend on next 1g maxsize 20g;

Tablespace altered.

SQL> conn / as sysdba
Connected.
SQL> select * from cdb_tablespace_usage_metrics;

TABLESPACE_NAME                USED_SPACE TABLESPACE_SIZE USED_PERCENT    CON_ID
------------------------------ ---------- --------------- ------------  ----------
.....
<tablespace>                    4189366         4194302   99.8823165      3 ====> No change
.....

16 rows selected.

- As we can see there was no size change reflected for above tablspace hence is the used percentage.

- Apapplied fixes 30372081 and 30668407 on but that is not helping as cdb_tablespace_usage_metrics and dba_tablespace_usage_metrics
are showing incorrect result.

Changes

 

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.