Minimum Data File Interval 2 (PI_PMDF)

Collection Interval

300

Y

Collection Offset

50

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

File #

(FILE_NUM)

File identification number

COPY

ushort

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$DATAFILE.FILE#

For locally managed temporary tablespaces:

V$TEMPFILE.FILE#

File Name

(NAME)

File name

COPY

string(513)

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$DATAFILE.NAME

For locally managed temporary tablespaces:

V$TEMPFILE.NAME

I/O Ops/sec

(IO_RATE)

Number of I/O operations per second

AVG

double

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

(V$FILESTAT.PHYRDS + V$FILESTAT.PHYWRTS) / seconds in interval

For locally managed temporary tablespaces:

(V$TEMPSTAT.PHYRDS + V$TEMPSTAT.PHYWRTS) / seconds in interval

Mbytes

(BYTES)

Percentage of disk space used by a file system, in megabytes

COPY

double

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$DATAFILE.BYTES / (1024 * 1024)

For locally managed temporary tablespaces:

V$TEMPFILE.BYTES / (1024 * 1024)

Physical Reads

(PHYSICAL_READS)

Number of physical block read operations that were completed during the interval

AVG

double

Yes

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$FILESTAT.PHYRDS

For locally managed temporary tablespaces:

V$TEMPSTAT.PHYRDS

Physical Writes

(PHYSICAL_WRITES)

Number of physical block write operations that were completed during the interval

AVG

double

Yes

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$FILESTAT.PHYWRTS

For locally managed temporary tablespaces:

V$TEMPSTAT.PHYWRTS

Reads/sec

(READ_RATE)

Number of read operations per second

AVG

double

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$FILESTAT.PHYRDS / seconds in interval

For locally managed temporary tablespaces:

V$TEMPSTAT.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 PMDF)

COPY

string(4)

No

All

Remote Monitor Collector

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 associated with the file

COPY

string(30)

No

All

For dictionary managed permanent tablespaces, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

DBA_DATA_FILES.TABLESPACE_NAME

For locally managed temporary tablespaces:

DBA_TEMP_FILES.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, dictionary managed temporary tablespaces, or locally managed permanent tablespaces:

V$FILESTAT.PHYWRTS / seconds in interval

For locally managed temporary tablespaces:

V$TEMPSTAT.PHYWRTS / seconds in interval