Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

Data File Interval (PI_PIDF)

Function

The Data File Interval (PI_PIDF) record stores performance data, taken at specific intervals, about data files. PFM - RM for Oracle creates one record for each data file in the database. This is a multi-instance record.

Default and changeable values

Item Default value Changeable
Collection Interval 300 Y
Collection Offset 40 Y
Log No Y
LOGIF (Blank) Y

ODBC key fields

Lifetime

From the creation to the deletion of a data file

Record size

Fields

PFM - View name
(PFM - Manager name)		 Description Summary Format Delta Supported version Data source
Blocks
(BLOCKS)		 Oracle block size #1 COPY 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 #1 COPY 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		 COPY 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 #1 COPY 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 #1 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
Free %
(PERCENT_FREE)		 Percentage ratio of free space #2 AVG 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 Change
(FREE_CHANGE)		 Change to the free space (the difference between the value obtained this time and the value obtained the last time) in megabytes#2 AVG 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)
Free Mbytes
(FREE_BYTES)		 Size of free space in megabytes #2 AVG 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 * 1024)
I/O Ops/sec
(IO_RATE)		 Number of I/O operations per second#2 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)		 Disk space in megabytes required on the file system#1 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 Blocks Read
(PHYSICAL_BLOCKS_READ)		 Number of physical block write operations during the interval#2 AVG double Yes 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 read operations during the interval#2 AVG double Yes 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 block read operations that were completed during the interval#2 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#2 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
Read Time
(READ_TIME)		 If the value of the TIMED_STATISTICS parameter in the init.ora file is TRUE, this field indicates the read operation time during the interval. If the parameter value is FALSE, this field contains 0.#2 AVG double Yes 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
Reads/sec
(READ_RATE)		 Number of read operations per second#2 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#1 COPY time_t No All Remote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)		 Record name (always PIDF)#1 COPY string(4) No All Remote Monitor Collector
Start Time
(START_TIME)		 Collection start time for the performance data stored in the record#1 COPY 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)#1 COPY 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 #1 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
Used Change
(USED_CHANGE)		 Change to the used space in megabytes. #2 AVG 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)
Used Mbytes
(USED_BYTES)		 Size of used area (the difference between the value obtained this time and the value obtained the last time) in megabytes #2 AVG 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 #2 AVG 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)		 If the value of the TIMED_STATISTICS parameter in the init.ora file is TRUE, this field indicates the write operation time during the interval. If the parameter value is FALSE, this field contains 0.#2 AVG double Yes 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
Writes/sec
(WRITES_RATE)		 Number of write operations per second#2 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

[Contents][Back][Next]

[Trademarks]

Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.