Hitachi

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


Collection Tablespace 2(PD_PCTS)

Organization of this page

Function

The Collection Tablespace 2 (PD_PCTS) record stores performance data indicating the status (at a specific point in time) of tablespaces in a database. PFM - Agent for Oracle creates one record for each transaction. This is a multi-instance record.

Default and changeable values

Item

Default Value

Changeable

Collection Interval

3600

Y

Collection Offset

30

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC Key Fields

PD_PCTS_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

Free Mbytes

(FREE_BYTES)

Remaining 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 tablespace when the value of localtemp_option is Y:

    SUM(DBA_TEMP_FILES.BYTES) - (V$SORT_SEGMENT.USED_EXTENTS * AVG(V$TEMP_EXTENT_MAP.BYTES) / (1024 * 1024)

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

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

Mbytes

(BYTES)

Size of tablespace in megabytes

--

double

No

All

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

    SUM(DBA_DATA_FILES.BYTES) / (1024 * 1024)

  • For locally managed temporary tablespaces:

    SUM(DBA_TEMP_FILES.BYTES) / (1024 * 1024)

Record Time

(RECORD_TIME)

Collection termination time for the performance data stored in the record

--

time_t

No

All

Agent Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PCTS)

--

string(4)

No

All

Agent Collector

Start Time

(START_TIME)

Collection start time for the performance data stored in the record

--

time_t

No

All

Agent Collector

Tablespace Name

(TABLESPACE_NAME)

Tablespace name

--

string(30)

No

All

DBA_TABLESPACES.TABLESPACE_NAME