My Oracle Support Banner

DUPLICATE ENTRIES IN CDB_TABLESPACE_USAGE_METRICS OR DBA_TABLESPACE_USAGE_METRICS (Doc ID 2576056.1)

Last updated on AUGUST 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.3.0.0.0 [Release 12.2 to 18]
Information in this document applies to any platform.

Symptoms

DUPLICATE ENTRIES IN CDB_TABLESPACE_USAGE_METRICS OR DBA_TABLESPACE_USAGE_METRICS 

select con_id,name,application_pdb,application_root from v$containers;

CON_ID NAME APP APP

---------- ------------------------------ --- ---

1 CDB$ROOT NO NO

2 PDB$SEED NO NO

3 PDB1 NO YES

4 PDB2 YES NO

select tablespace_name,con_id from cdb_tablespaces where tablespace_name='USERS';

TABLESPACE_NAME CON_ID

------------------------------ ----------

USERS 3

USERS 1

USERS 4

select tablespace_name,used_space,con_id from cdb_tablespace_usage_metrics where tablespace_name='USERS';

TABLESPACE_NAME USED_SPACE CON_ID

------------------------------ ---------- ----------

USERS 144 1

USERS 128 3 *** duplicate

USERS 144 3 *** duplicate 

USERS 144 4

 

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.