Hitachi

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


Tablespace Interval (PI_PITS)

Organization of this page

Function

The Tablespace Interval (PI_PITS) 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

50

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC key fields

PI_PITS_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

Datafiles

(DATAFILES)

Number of data files in use by the tablespace#2

AVG

ulong

No

All

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

    COUNT(DBA_DATA_FILES)

  • For locally managed temporary tablespaces:

    COUNT(DBA_TEMP_FILES)

I/O Ops/sec

(IO_RATE)

Number of I/O operations per second#2

AVG

double

No

All

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

Physical Blocks Read

(PHYSICAL_BLOCKS_READ)

Number of physical blocks read#2

AVG

double

Yes

All

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

    SUM(V$FILESTAT.PHYBLKRD)

  • For locally managed temporary tablespaces:

    SUM(V$TEMPSTAT.PHYBLKRD)

Physical Blocks Written

(PHYSICAL_BLOCKS_WRITTEN)

Number of physical blocks written#2

AVG

double

Yes

All

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

    SUM(V$FILESTAT.PHYBLKWRT)

  • Locally managed temporary tablespaces:

    SUM(V$TEMPSTAT.PHYBLKWRT)

Physical Reads

(PHYSICAL_READS)

Number of physical read operations that were completed#2

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 #2

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#2

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

COPY

time_t

No

All

Remote Monitor Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PITS)#1

COPY

string(4)

No

All

Remote Monitor Collector

Rollback Segments

(ROLLBACK_SEGMENTS)

Number of rollback segments.

Performance data about the locally managed tablespaces is not collected.#2

AVG

ulong

No

All

COUNT(DBA_ROLLBACK_SEGS)

Rollback Segments Hit %

(ROLLBACK_SEGMENTS_HIT_PERCENTAGE)

Percentage ratio of the HIT value to the GET value.

Performance data about locally managed tablespaces is not collected.#2

AVG

double

No

All

((SUM(V$ROLLSTAT.GETS) - SUM(V$ROLLSTAT.WAITS)) / SUM(V$ROLLSTAT.GETS)) * 100

Rollback Segments Trans

(ROLLBACK_SEGMENTS_TRANS)

Number of transactions that were active during data collection.

Performance data about locally managed temporary tablespace is not collected.#2

AVG

long

No

All

SUM(V$ROLLSTAT.XACTS)

Sort Segments

(SORT_SEGMENTS)

Number of sort segments.

Performance data about locally managed permanent tablespaces is not collected.#2

AVG

ulong

No

All

COUNT(V$SORT_SEGMENT)

Sorting Users

(SORTING_USERS)

Number of users that were active in the sort segment during data collection.

Performance data about locally managed permanent tablespaces is not collected.#2

AVG

long

No

All

SUM(V$SORT_SEGMENT.CURRENT_USERS)

Start Time

(START_TIME)

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

COPY

time_t

No

All

Remote Monitor Collector

Tablespace Name

(TABLESPACE_NAME)

Tablespace name#1

COPY

string(30)

No

All

DBA_TABLESPACES.TABLESPACE_NAME

VA DeviceID

(VADEVICEID)

Device ID of virtual agent.

--

string(256)

No

All

Remote Monitor Collector

Write %

(WRITE_PERCENTAGE)

Percentage ratio of write operations to all physical I/O operations #2

AVG

double

No

All

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

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

  • For locally managed temporary tablespaces:

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

Writes/sec

(WRITES_RATE)

Number of write operations per second#2

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