Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference

Data File Interval (PI_PIDF)

Organization of this page

Function

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

To Page Top

Default and changeable values

Item

Default value

Changeable

Collection Interval

300

Y

Collection Offset

40

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

To Page Top

ODBC key fields

To Page Top

Lifetime

From the creation to the deletion of a data file

To Page Top

Record size

To Page Top

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: #1

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

long

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 N:

    (V$TEMP_SPACE_HEADER / V$TEMPFILE.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 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 N:

    (V$TEMP_SPACE_HEADER.BYTES_FREE) / (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 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)

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 N:

    (V$TEMP_SPACE_HEADER.BYTES_FREE) / (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 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. In centiseconds (1/100 of a second).#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

Agent Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PIDF)#1

COPY

string(4)

No

All

Agent Collector

Start Time

(START_TIME)

Collection start time for the performance data stored in the record#1

COPY

time_t

No

All

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

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 N:

    (V$TEMPFILE.BYTES - V$TEMP_SPACE_HEADER.BYTES_FREE) / (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 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)

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 N:

    (V$TEMPFILE.BYTES - V$TEMP_SPACE_HEADER.BYTES_FREE) / (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 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)

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. In centiseconds (1/100 of a second).#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

To Page Top

Copyright (C) 2019, 2020, Hitachi, Ltd.

Copyright (C) 2019, 2020, Hitachi Solutions, Ltd.