Hitachi

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


Minimum Tablespace Interval 2 (PI_PMTS)

Organization of this page

Function

The Minimum Tablespace Interval 2 (PI_PMTS) 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.

Default and changeable values

Item

Default Value

Changeable

Collection Interval

3600

Y

Collection Offset

1510

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC key fields

PI_PMTS_TABLESPACE_NAME

Lifetime

From the creation to the deletion of a tablespace

Record Size

Fields

PFM - View name

(PFM - Manager name)

Description

Summary

Format

Delta

Supported Version

Data Source

I/O Ops/sec

(IO_RATE)

Number of I/O operations per second

AVG

double

No

All

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

Physical Reads

(PHYSICAL_READS)

Number of physical read operations that were completed

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

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

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

COPY

time_t

No

All

Remote Monitor Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PMTS)#1

COPY

string(4)

No

All

Remote Monitor Collector

Rollback Segments

(ROLLBACK_SEGMENTS)

Number of rollback segments. Performance data about a locally managed tablespace is not collected.#2

AVG

ulong

No

All

COUNT(DBA_ROLLBACK_SEGS)

Sort Segments

(SORT_SEGMENTS)

Number of sort segments. Performance data about a locally managed permanent tablespace is not collected.#2

AVG

ulong

No

All

COUNT(V$SORT_SEGMENT)

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

COPY

string(30)

No

All

DBA_TABLESPACES.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, 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