The Tablespace Interval (PI_PITS) 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	50	Y
Log	No	Y
LOGIF	(Blank)	Y

PI_PITS_TABLESPACE_NAME

From the creation to the deletion of a tablespace

• Fixed part: 935 bytes
• Variable part: 291 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Datafiles (DATAFILES)	Number of data files in use by the tablespace#2	AVG	ulong	No	All	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)
I/O Ops/sec (IO_RATE)	Number of I/O operations per second#2	AVG	double	No	All	(SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS)) / seconds in interval
Physical Blocks Read (PHYSICAL_BLOCKS_READ)	Number of physical blocks read#2	AVG	double	Yes	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(V$FILESTAT.PHYBLKRD) For locally managed temporary tablespaces: SUM(V$TEMPSTAT.PHYBLKRD)
Physical Blocks Written (PHYSICAL_BLOCKS_WRITTEN)	Number of physical blocks written#2	AVG	double	Yes	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: SUM(V$FILESTAT.PHYBLKWRT) Locally managed temporary tablespaces: SUM(V$TEMPSTAT.PHYBLKWRT)
Physical Reads (PHYSICAL_READS)	Number of physical read operations that were completed#2	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 #2	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#2	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#1	COPY	time_t	No	All	Remote Monitor Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always PITS)#1	COPY	string(4)	No	All	Remote Monitor Collector
Rollback Segments (ROLLBACK_SEGMENTS)	Number of rollback segments. Performance data about the locally managed tablespaces is not collected.#2	AVG	ulong	No	All	COUNT(DBA_ROLLBACK_SEGS)
Rollback Segments Hit % (ROLLBACK_SEGMENTS_HIT_PERCENTAGE)	Percentage ratio of the HIT value to the GET value. Performance data about locally managed tablespaces is not collected.#2	AVG	double	No	All	((SUM(V$ROLLSTAT.GETS) - SUM(V$ROLLSTAT.WAITS)) / SUM(V$ROLLSTAT.GETS)) * 100
Rollback Segments Trans (ROLLBACK_SEGMENTS_TRANS)	Number of transactions that were active during data collection. Performance data about locally managed temporary tablespace is not collected.#2	AVG	long	No	All	SUM(V$ROLLSTAT.XACTS)
Sort Segments (SORT_SEGMENTS)	Number of sort segments. Performance data about locally managed permanent tablespaces is not collected.#2	AVG	ulong	No	All	COUNT(V$SORT_SEGMENT)
Sorting Users (SORTING_USERS)	Number of users that were active in the sort segment during data collection. Perforamance data about locally managed permanent tablespaces is not collected.#2	AVG	long	No	All	SUM(V$SORT_SEGMENT.CURRENT_USERS)
Start Time (START_TIME)	Collection start time for the performance data stored in the record#1	COPY	time_t	No	All	Remote Monitor Collector
Tablespace Name (TABLESPACE_NAME)	Tablespace name#1	COPY	string(30)	No	All	DBA_TABLESPACES.TABLESPACE_NAME
VA DeviceID (VADEVICEID)	Device ID of virtual agent.	--	string(256)	No	All	Remote Monitor Collector
Write % (WRITE_PERCENTAGE)	Percentage ratio of write operations to all physical I/O operations #2	AVG	double	No	All	For dictionary managed permanent tablespaces, locally managed permanent tablespaces, or dictionary managed temporary tablespaces: (SUM(V$FILESTAT.PHYWRTS) / (SUM(V$FILESTAT.PHYRDS) + SUM(V$FILESTAT.PHYWRTS))) * 100 For locally managed temporary tablespaces: (SUM(V$TEMPSTAT.PHYWRTS) / SUM(V$TEMPSTAT.PHYWRTS) + SUM(V$TEMPSTAT.PHYRDS)) * 100
Writes/sec (WRITES_RATE)	Number of write operations per second#2	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