CDB Tablespace(PD_CDTS)

Function

The CDB Tablespace (PD_CDTS) record stores performance data indicating the status concerning the size of the tablespaces of all the containers managed by the root container of the CDB at a certain point in time. One record is created per tablespace. This record is a multiple-instance record.

The CDB Tablespace (PD_CDTS) record differs from the Tablespace (PD_PDTS) record in the following respects.

Range of information collected

Record	Oracle Database to be monitored	Range of information collected
CDB Tablespace (CD_CDTS)	Root container (CDB$ROOT) in a CDB configuration	When an Oracle administrative account (sys or system) is used: Performance data concerning the root container (CDB$ROOT) and all the PDBs managed by it When a common user's account is used: Performance data concerning the root container (CDB$ROOT)
	PDBs in a CDB configuration	Performance data concerning monitored PDBs
	Non-CDB configuration	Performance data concerning the monitored Oracle Database
Tablespace (PD_PDTS)	Root container (CDB$ROOT) in a CDB configuration	Performance data concerning the root container (CDB$ROOT)
	PDBs in a CDB configuration	Performance data concerning the monitored PDBs
	Non-CDB configuration	Performance data concerning the monitored Oracle Database

Maximum size of automatic expansion

Record	Tablespace	Maximum size of automatic expansion
CDB Tablespace (CD_CDTS)	Permanent tablespace/temporary tablespaces	The maximum size of automatic expansion defined in the tablespace or the free space of the file system, whichever is smaller
	UNDO tablespaces	The maximum size of automatic expansion defined in the tablespace
Tablespace (PD_PDTS)	All tablespaces	The maximum size of automatic expansion defined in the tablespace

The following figure shows the relationship between the fields acquired with the CDB Tablespace (PD_CDTS) record.

Figure 6‒3: Relationship between the fields acquired with tablespaces (except UNDO tablespaces)

When free space of the file system is smaller than the maximum size of automatic expansion defined in the tablespace, the value of the Max Extend Mbytes field is calculated based on the amount of free space. Other fields are calculated based on the value of the Max Extend Mbytes field.

Figure 6‒4: Relationship between the fields acquired with tablespaces (UNDO tablespaces)

The maximum size of automatic expansion defined in the tablespace is displayed as the value of the Max Extend Mbytes field. If the maximum size is unlimited, the value is displayed based on the theoretical maximum size that can be set with the Oracle Database. Other fields are calculated based on the value of the Max Extend Mbytes field.

The unused size (which is equivalent to setting localtemp_option to Y in instance information) is displayed as the size of a temporary tablespace. The displayed size of the UNDO tablespace varies depending on the specification of undospace_option in instance information. For more details, see the information about the effect of undospace_option provided in the Tablespace (PD_PDTS) record.

Notes

• The CDB Tablespace (PD_CDTS) record is supported only when Oracle Database 12c R2 or later is monitored. Information cannot be collected when Oracle Database 12c R1 or earlier is monitored.

• This record can be collected when either a CDB or non-CDB configuration is monitored.

• If a CDB configuration is monitored, the range of information collected varies depending on whether it is a PDB or the root container (CDB$ROOT) that is going to be monitored.

To Page Top

Default and changeable values

Item	Default value	Changeable
Collection Interval	3600	Y
Collection Offset	0	Y
Log	No	Y
LOGIF	(Blank)	Y

To Page Top

ODBC key fields

• PD_CDTS_CON_ID

• PD_CDTS_TABLESPACE_NAME

To Page Top

Lifetime

From creation to deletion of a tablespace

To Page Top

Record size

• Fixed part: 678 bytes

• Variable part: 145 bytes

To Page Top

Fields

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Auto Extensible (AUTO_EXTENSIBLE)	This field indicates whether the automatic expansion of the tablespace is enabled. YES means enabled and NO means disabled. This field is set to YES when automatic expansion is enabled for any one of the data files of which the tablespace is comprised.	--	string(3)	No	Oracle 12c R2 or later	For tablespaces other than temporary tablespaces: CDB_DATA_FILES.AUTOEXTENSIBLE For temporary tablespaces: CDB_TEMP_FILES.AUTOEXTENSIBLE
Block Size (BLOCK_SIZE)	Block size of the tablespace	--	ulong	No	Oracle 12c R2 or later	CDB_TABLESPACES.BLOCK_SIZE
Container ID (CON_ID)	ID of the container to which the tablespace belongs	--	ushort	No	Oracle 12c R2 or later	CDB_TABLESPACES.CON_ID
Contents (CONTENTS)	Contents of the tablespace	--	string(21)	No	Oracle 12c R2 or later	CDB_TABLESPACES.CONTENTS
Extensible Mbytes (EXTENSIBLE_BYTES)	The remaining space available for automatic expansion in megabytes. This field is set to 0 when no automatic expansion is performed or when the maximum size is already reached.	--	double	No	Oracle 12c R2 or later	MAX_BYTES - BYTES
Extensible Mbytes % (PERCENT_EXTENSIBLE_BYTES)	Percentage ratio of the remaining space available for automatic expansion. This field is set to 0 when no automatic expansion is performed or when the maximum size is already reached.	--	double	No	Oracle 12c R2 or later	(EXTENSIBLE_BYTES / MAX_BYTES) * 100
Free % (PERCENT_FREE)	Percentage ratio of free space	--	double	No	Oracle 12c R2 or later	(FREE_BYTES / BYTES) * 100
Free Mbytes (FREE_BYTES)	Size of free space in megabytes	--	double	No	Oracle 12c R2 or later	For UNDO tablespaces: CDB_DATA_FILES.BYTES - (CDB_TABLESPACE_USAGE_METRICS.USED_SPACE * CDB_TABLESPACE.BLOCK_SIZE) / (1024 * 1024) For the UNDO tablespaces when the value of undospace_option is Y: (SUM(CDB_FREE_SPACE.BYTES) + SUM(CDB_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / (1024 * 1024) For the UNDO tablespaces when the value of undospace_option is N: (SUM(CDB_FREE_SPACE.BYTES) / (1024 * 1024)
Max Extend Free % (MAX_PERCENT_FREE)	Percentage ratio of the unused size in relation to the maximum automatically expandable size. The value is the same as the Free % field when automatic expansion is disabled or the maximum size has already been reached.	--	double	No	Oracle 12c R2 or later	(MAX_FREE_BYTES / MAX_BYTES) * 100
Max Extend Free Mbytes (MAX_FREE_BYTES)	Size unused when automatic expansion is enabled. This size is the total of the unused size and the automatically expandable size in megabytes. The value is the same as the Free Mbytes field when automatic expansion is disabled or the maximum size has already been reached.	--	double	No	Oracle 12c R2 or later	MAX_BYTES - USED_BYTES
Max Extend Mbytes (MAX_BYTES)	Maximum automatic expandable size (in megabytes). The value is the same as the Mbytes field when automatic expansion is disabled or the maximum size has already been reached.	--	double	No	Oracle 12c R2 or later	For tablespaces other than UNDO tablespaces: (CDB_TABLESPACE_USAGE_METRICS.TABLESPACE_SIZE * CDB_TABLESPACES.BLOCK_SIZE) / (1024 * 1024) For UNDO tablespaces: SUM(CDB_DATA_FILES.MAXBYTES) / (1024 * 1024)
Mbytes (BYTES)	Size of the tablespace in megabytes	--	double	No	Oracle 12c R2 or later	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(CDB_DATA_FILES.BYTES) / (1024 * 1024) For locally managed temporary tablespaces: SUM(CDB_TEMP_FILES.BYTES) / (1024 * 1024)
Record Time (RECORD_TIME)	Collection termination time for the performance data stored in the record	--	time_t	No	Oracle 12c R2 or later	Agent Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always CDTS)	--	string(4)	No	Oracle 12c R2 or later	Agent Collector
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	time_t	No	Oracle 12c R2 or later	Agent Collector
Status (STATUS)	Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, ONLINE, and READ ONLY.	--	string(9)	No	Oracle 12c R2 or later	CDB_TABLESPACES.STATUS
Tablespace Name (TABLESPACE_NAME)	Tablespace name	--	string(30)	No	Oracle 12c R2 or later	CDB_TABLESPACES.TABLESPACE_NAME
Used Mbytes (USED_BYTES)	Size of used area in megabytes.#4	--	double	No	Oracle 12c R2 or later	For tablespaces other than UNDO tablespaces: (CDB_TABLESPACE_USAGE_METRICS.USED_SPACE * CDB_TABLESPACES.BLOCK_SIZE) / (1024 * 1024) For UNDO tablespaces: BYTES - FREE_BYTES

To Page Top