The Minimum Tablespace Interval 2 (PI_PMTS) record stores performance data, taken at specific intervals, about 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	1510	Y
Log	No	Y
LOGIF	(Blank)	Y

PI_PMTS_TABLESPACE_NAME

From the creation to the deletion of a tablespace

• Fixed part: 935 bytes
• Variable part: 163 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported Version	Data Source
I/O Ops/sec (IO_RATE)	Number of I/O operations per second	AVG	double	No	All	(SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval
Physical Reads (PHYSICAL_READS)	Number of physical read operations that were completed	AVG	double	Yes	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(V$FILESTAT.PHYRDS) For locally managed temporary tablespaces: SUM(V$TEMPSTAT.PHYRDS)
Physical Writes (PHYSICAL_WRITES)	Number of physical write operations that were completed	AVG	double	Yes	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(V$FILESTAT.PHYWRTS) For locally managed temporary tablespaces: SUM(V$TEMPSTAT.PHYWRTS)
Reads/sec (READ_RATE)	Number of read operations per second	AVG	double	No	All	SUM(V$FILESTAT.PHYRDS)/ seconds in interval
Record Time (RECORD_TIME)	Collection termination time for the performance data stored in the record	COPY	time_t	No	All	Remote Monitor Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always PMTS)#1	COPY	string(4)	No	All	Remote Monitor Collector
Rollback Segments (ROLLBACK_SEGMENTS)	Number of rollback segments. Performance data about a locally managed tablespace is not collected.#2	AVG	ulong	No	All	COUNT(DBA_ROLLBACK_SEGS)
Sort Segments (SORT_SEGMENTS)	Number of sort segments. Performance data about a locally managed permanent tablespace is not collected.#2	AVG	ulong	No	All	COUNT(V$SORT_SEGMENT)
Start Time (START_TIME)	Collection start time for the performance data stored in the record	COPY	time_t	No	All	Remote Monitor Collector
Tablespace Name (TABLESPACE_NAME)	Tablespace name	COPY	string(30)	No	All	DBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID (VADEVICEID)	Device ID of virtual agent.	--	string(256)	No	All	Remote Monitor Collector
Writes/sec (WRITES_RATE)	Number of write operations per second	AVG	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(V$FILESTAT.PHYWRTS) / seconds in interval For locally managed temporary tablespaces: SUM(V$TEMPSTAT.PHYWRTS) / seconds in interval