Hitachi

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


Block Contention Statistics (PD_PDBC)

Organization of this page

Function

The Block Contention Statistics (PD_PDBC) record stores performance data indicating the status of each wait class at a specific point in time. To collect this record, you must specify TRUE in the TIMED_STATISTICS parameter in the init.ora Oracle initialization parameter file.

PFM - Agent for Oracle creates one record for each wait class. This is a multi-instance record.

Default and changeable values

Item

Default Value

Changeable

Collection Interval

600

Y

Collection Offset

5

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC Key Fields

PD_PDBC_CLASS

Lifetime

From the creation to the deletion of an Oracle instance

Record Size

Fields

PFM - View name

(PFM - Manager name)

Description

Summary

Format

Delta

Supported Version

Data Source

Class

(CLASS)

Block class

--

string(19)

No

All

V$WAITSTAT.CLASS

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

--

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

Wait Count

(WAIT_COUNT)

Number of OPERATION waits for the block's class.

--

double

No

All

V$WAITSTAT.COUNT

Wait Time

(WAIT_TIME)

Total OPERATION wait time for the block's class

--

double

No

All

V$WAITSTAT.TIME