The Tablespace (PD_PDTS) 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 tablespace in a database. 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_PDTS_TABLESPACE_NAME

From the creation to the deletion of a tablespace

• Fixed part: 935 bytes
• Variable part: 119 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Blocks (BLOCKS)	Size of tablespace in Oracle blocks	--	ulong	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(DBA_DATA_FILES.BLOCKS) For locally managed temporary tablespaces: SUM(DBA_TEMP_FILES.BLOCKS)
Data Files (DATAFILES)	Number of data files in use by the tablespace	--	ulong	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: COUNT(DBA_DATA_FILES) For locally managed temporary tablespaces: COUNT(DBA_TEMP_FILES)
Extents (EXTENTS)	Number of extents	--	ulong	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or directory managed temporary tablespaces: SUM(DBA_SEGMENTS.EXTENTS) For locally managed temporary tablespaces when the value of localtemp_option is Y: SUM(DBA_TEMP_FILES.BYTES / V$TEMP_EXTENT_MAP.BYTES) For locally managed temporary tablespaces when the value of localtemp_option is N: SUM(V$SORT_SEGMENT.TOTAL_EXTENTS)
Free % (PERCENT_FREE)	Percentage ratio of free space	--	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) / DBA_DATA_FILES.BYTES) * 100 For locally managed temporary tablespaces when the value of localtemp_option is Y: (SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (DBA_TEMP_FILES.BYTES)) * 100 For locally managed temporary tablespaces when the value of localtemp_option is N: (SUM(V$TEMP_SPACE_HEADER.BYTES_FREE) / (DBA_TEMP_FILES.BYTES)) * 100 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') / DBA_DATA_FILES.BYTES) * 100
Free Extents (FREE_EXTENTS)	Number of free extents.	--	ulong	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: COUNT(DBA_FREE_SPACE) For locally managed temporary tablespaces when the value of localtemp_option is Y: SUM((DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / V$TEMP_EXTENT_MAP.BYTES) For locally managed temporary tablespaces when the value of localtemp_option is N: COUNT(V$TEMP_SPACE_HEADER)
Free Mbytes (FREE_BYTES)	Size of 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 tablespaces 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 tablespaces 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)
Increase % (PCT_INCREASE)	Default rate of increase in the extent size	--	short	No	All	DBA_TABLESPACES.PCT_INCREASE
Initial Extent (INITIAL_EXTENT)	Default size of the initial extent	--	double	No	All	DBA_TABLESPACES.INITIAL_EXTENT
Max Extents (MAX_EXTENTS)	Default maximum number of extents	--	ulong	No	All	DBA_TABLESPACES.MAX_EXTENTS
Mbytes (BYTES)	Size of the tablespace in megabytes	--	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(DBA_DATA_FILES.BYTES) / (1024 * 1024) For locally managed temporary tablespaces: SUM(DBA_TEMP_FILES.BYTES) / (1024 * 1024)
Min Extents (MIN_EXTENTS)	Default minimum number of extents	--	long	No	All	DBA_TABLESPACES.MIN EXTENTS
Next Extent (NEXT_EXTENT)	Default size of the incremental extent	--	double	No	All	DBA_TABLESPACES.NEXT_EXTENT
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 PDTS)	--	string(4)	No	All	Remote Monitor Collector
Segments (SEGMENTS)	Number of segments. Always 1 for locally managed temporary tablespaces when the value of localtemp_option is Y.	--	ulong	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: COUNT(DBA_SEGMENTS) For locally managed temporary tablespaces when the value of localtemp_option is Y: Remote Monitor Collector For locally managed temporary tablespaces when the value of localtemp_option is N: COUNT(V$SORT_SEGMENT)
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	Time_t	No	All	Remote Monitor Collector
Status (STATUS)	Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, and ONLINE.	--	string(9)	No	All	DBA_TABLESPACES STATUS
Tablespace Name (TABLESPACE_NAME)	Tablespace name	--	string(30)	No	All	DBA_TABLESPACES.TABLESPACE_NAME
Used Mbytes (USED_BYTES)	Size of used area 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_DATA_FILES.BYTES) -SUM(DBA_FREE_SPACE.BYTES)) / (1024 *1024) For locally managed temporary tablespaces when the value of localtemp_option is Y: (SUM(DBA_TEMP_FILES.BYTES) - SUM(DBA_TEMP_FILES.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED)) / (1024 *1024) For locally managed temporary tablespaces when the value of localtemp_option is N: (SUM(DBA_TEMP_FILES.BYTES) - SUM(V$TEMP_SPACE_HEADER.BYTES_FREE)) / (1024 *1024) For the UNDO tablespaces when the value of undospace_option is Y: (DBA_DATA_FILES.BYTES - SUM(DBA_FREE_SPACE.BYTES) - SUM(DBA_UNDO_EXTENTS.BYTES) WHERE STATUS='EXPIRED') / (1024 * 1024)
VA DeviceID (VADEVICEID)	Device ID of virtual agent.	--	string(256)	No	All	Remote Monitor Collector