Hitachi

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


Resource Limit (PD_PDRL)

Organization of this page

Function

The Resource Limit (PD_PDRL) record stores performance data indicating the usage of global system resources at a specific point in time. PFM - Agent for Oracle creates one record for each system resource. This is a multi-instance record.

Default and changeable values

Item

Default value

Changeable

Collection Interval

600

Y

Collection Offset

25

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC key fields

PD_PDRL_RESOURCE_NAME

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

Current Utilization

(CURRENT_UTILIZATION)

Number of locks, resources, or processes currently in use

--

double

No

All

V$RESOURCE_LIMIT.CURRENT_UTILIZATION

Initial Allocation

(INITIAL_ALLOCATION)

Initial allocation (value specified in initialization parameter file)

--

string(10)

No

All

V$RESOURCE_LIMIT.INITIAL_ALLOCATION

Limit Value

(LIMIT_VALUE)

Limit value for locks and resources (the value of this field can be greater than the initial allocation value; in the case of unlimited allocation, the value of this field is UNLIMITED)

--

string(10)

No

All

V$RESOURCE_LIMIT.LIMIT_VALUE

Max Utilization

(MAX_UTILIZATION)

Maximum amount of resources used since the last instance started

--

double

No

All

V$RESOURCE_LIMIT.MAX_UTILIZATION

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

--

string(4)

No

All

Agent Collector

Resource Name

(RESOURCE_NAME)

Resource name

--

string(30)

No

All

V$RESOURCE_LIMIT.RESOURCE_NAME

Start Time

(START_TIME)

Collection start time for the performance data stored in the record

--

time_t

No

All

Agent Collector

Utilization %

(UTILIZATION_PERCENT)

Ratio (as a percent) of the current utilization value to the maximum utilization value

--

double

No

All

CURRENT_UTILIZATION / MAX_UTILIZATION * 100