Data File (PD_PDDF)

Collection Interval

300

Y

Collection Offset

10

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

Blocks

(BLOCKS)

Oracle block size

--

double

No

All

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

  DBA_DATA_FILES.BLOCKS

• For locally managed temporary tablespaces:

  DBA_TEMP_FILES.BLOCKS

Checkpoint Change #

(CHECKPOINT_CHANGE_NUM)

System change number (SCN) at the last checkpoint

--

double

No

All

V$DATAFILE.CHECKPOINT_CHANGE#

Enabled

(ENABLED)

This field contains one of the following values as the method for accessing a file using SQL:

DISABLED

READ ONLY

READ WRITE

UNKNOWN

--

string(10)

No

All

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

  V$DATAFILE.ENABLED

• For locally managed temporary tablespaces:

  V$TEMPFILE.ENABLED

File #

(FILE_NUM)

File identification number

--

ulong

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

--

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

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) / V$DATAFILE.BYTES) * 100

• For locally managed temporary tablespaces when the value of localtemp_option is Y:

  ((V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / V$TEMPFILE.BYTES) * 100

• For locally managed temporary tablespaces when the value of localtemp_option is N:

  (V$TEMP_SPACE_HEADER / V$TEMPFILE.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') / V$DATAFILE.BYTES) * 100

Free Mbytes

(FREE)

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:

  (V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED) / (1024 * 1024)

• For locally managed temporary tablespaces when the value of localtemp_option is N:

  (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)

Disk space in megabytes required on the file system

--

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 Blocks Read

(PHYSICAL_BLOCKS_READ)

Number of physical block read operations

--

double

No

All

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

  V$FILESTAT.PHYBLKRD

• For locally managed temporary tablespaces:

  V$TEMPSTAT.PHYBLKRD

Physical Blocks Written

(PHYSICAL_BLOCKS_WRITTEN)

Number of physical block write operations

--

double

No

All

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

  V$FILESTAT.PHYBLKWRT

• For locally managed temporary tablespaces:

  V$TEMPSTAT.PHYBLKWRT

Physical Reads

(PHYSICAL_READS)

Number of physical read operations that were completed

--

double

No

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 write operations that were completed

--

double

No

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

Read Time

(READ_TIME)

Read operation time. In centiseconds (1/100 of a second).

--

double

No

All

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

  V$FILESTAT.READTIM

• For locally managed temporary tablespaces:

  V$TEMPSTAT.READTIM

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 PDDF)

--

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

Status

(STATUS)

File type (system file or user file) and file status (OFFLINE, SYSOFF, ONLINE, SYSTEM, or RECOVER)

--

string(7)

No

All

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

  V$DATAFILE.STATUS

• For locally managed temporary tablespaces:

  V$TEMPFILE.STATUS

Tablespace Name

(TABLESPACE_NAME)

Tablespace name associated with the file

--

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

Used Mbytes

(USED)

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:

  (V$DATAFILE.BYTES - SUM(DBA_FREE_SPACE.BYTES)) / (1024 * 1024)

• For locally managed temporary tablespaces when the value of localtemp_option is Y:

  (V$TEMPFILE.BYTES - (V$TEMPFILE.BYTES - V$TEMP_EXTENT_POOL.BYTES_USED)) / (1024 * 1024)

• For locally managed temporary tablespaces when the value of localtemp_option is N:

  (V$TEMPFILE.BYTES - V$TEMP_SPACE_HEADER.BYTES_FREE) / (1024 * 1024)

• For the UNDO tablespaces when the value of undospace_option is Y:

  (V$DATAFILE.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

Write %

(WRITE_PERCENTAGE)

Percentage ratio of write operations

--

double

No

All

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

  (V$FILESTAT.PHYWRTS / (V$FILESTAT.PHYRDS + V$FILESTAT.PHYWRTS)) * 100

• For locally managed temporary tablespaces:

  ((V$TEMPSTAT.PHYWRTS / (V$TEMPSTAT.PHYRDS + V$TEMPSTAT.PHYWRTS)) * 100

Write Time

(WRITE_TIME)

Write operation time. In centiseconds (1/100 of a second).

--

double

No

All

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

  V$FILESTAT.WRITETIM

• For locally managed temporary tablespaces:

  V$TEMPSTAT.WRITETIM