The Collection Tablespace 2 (PD_PCTS) record stores performance data indicating the status (at a specific point in time) of tablespaces in a database. PFM - RM for Oracle creates one record for each transaction. This is a multi-instance record.

Item	Default Value	Changeable
Collection Interval	3600	Y
Collection Offset	30	Y
Log	No	Y
LOGIF	(Blank)	Y

PD_PCTS_TABLESPACE_NAME

From the creation to the deletion of a tablespace

• Fixed part: 935 bytes
• Variable part: 47 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported Version	Data Source
Free Mbytes (FREE_BYTES)	Remaining free space in megabytes.	--	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, dictionary managed temporary tablespaces, or the UNDO tablespaces when the value of undospace_option is N: SUM(DBA_FREE_SPACE.BYTES) / (1024 * 1024) For locally managed temporary tablespace when the value of localtemp_option is Y: SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (1024 * 1024) For locally managed temporary tablespace when the value of localtemp_option is N: SUM(V$TEMP_SPACE_HEADER.BYTES_FREE)) / (1024 * 1024) For the UNDO tablespaces when the value of undospace_option is Y: (SUM(DBA_FREE_SPACE.BYTES) + SUM(DBA_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / (1024 x 1024)
Mbytes (BYTES)	Size of tablespace in megabytes	--	double	No	All	For dictionary managed permanent tablespaces, locally managed tablespaces, or dicationary managed temporary tablespaces: SUM(DBA_DATA_FILES.BYTES) / (1024 * 1024) For locally managed temporary tablespaces: SUM(DBA_TEMP_FILES.BYTES) / (1024 * 1024)
Record Time (RECORD_TIME)	Collection termination time for the performance data stored in the record	--	time_t	No	All	Remote Monitor Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always PCTS)	--	string(4)	No	All	Remote Monitor Collector
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	time_t	No	All	Remote Monitor Collector
Tablespace Name (TABLESPACE_NAME)	Tablespace name	--	string(30)	No	All	DBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID (VADEVICEID)	Device ID of virtual agent	--	string(256)	No	All	Remote Monitor Collector