EM 12c: Tablespace Size Not Computed Correctly In Pluggable Database, Showing Only Default 0.85GB Usage in Enterprise Manager 12c Cloud Control (Doc ID 2041572.1)

Last updated on JULY 15, 2017

Applies to:

Enterprise Manager for Chargeback and Capacity Planning - Version 12.1.0.6.0 to 12.1.0.6.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.6.0 Cloud Control, Target: Chargeback


Tablespace Size not computed correctly for a  Pluggable database, showing only the default value of 0.85GB usage

 > select NAME from v$pdbs where con_id =4;

NAME
------------------------------
CBKDEV

SYS@GDOS01C1 >

 > select TABLESPACE_NAME from cdb_tablespaces where CON_ID=4;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
CBKDATA
CBKINDX


 > select FILE_NAME, BYTES/1024/1024, TABLESPACE_NAME from cdb_data_files where CON_ID=4 order by 3;

FILE_NAME BYTES/1024/1024 TABLESPACE_NAME
------------------------------------------------------------------------------------------ --------------- ------------------------------
+DATA_GDOS/GDOS01C/17244FC576E10044E0530A4D3302896F/DATAFILE/cbkdata.266.880899395 2490.74219 CBKDATA
+DATA_GDOS/GDOS01C/17244FC576E10044E0530A4D3302896F/DATAFILE/cbkindx.259.880902647 100 CBKINDX
+DATA_GDOS/GDOS01C/17244FC576E10044E0530A4D3302896F/DATAFILE/sysaux.268.880899321 635 SYSAUX
+DATA_GDOS/GDOS01C/17244FC576E10044E0530A4D3302896F/DATAFILE/system.265.880899323 350 SYSTEM





Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms