Hitachi

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


Open Cursor (PD_PDOC)

Organization of this page

Function

The Open Cursor (PD_PDOC) record stores performance data indicating the status (at a specific point in time) of cursors. PFM - Agent for Oracle creates one record for each open cursor in the system. This is a multi-instance record.

Default and changeable values

Item

Default value

Changeable

Collection Interval

600

Y

Collection Offset

75

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC key fields

Lifetime

From the opening to the closing of the cursor

Record size

Fields

PFM - View name

(PFM - Manager name)

Description

Summary

Format

Delta

Supported version

Data source

Addrhash

(ADDRHASH)

Character string that identifies the SQL statement being executed

--

string(38)

No

All

V$OPEN_CURSOR.ADDRESS + V$OPEN_CURSOR.HASH_VALUE

Program

(PROGRAM)

Name of the program being executed

--

string(48)

No

All

V$SESSION.PROGRAM where V$OPEN_CURSOR.SID = V$SESSION.SID

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

--

string(4)

No

All

Agent Collector

SID

(SID)

Session ID

--

ulong

No

All

V$SESSION.SID where V$OPEN_CURSOR.SID = V$SESSION.SID

SQL Text

(SQL_TEXT)

First 60 characters of the SQL statement that is analyzed by the open cursor

--

string(60)

No

All

V$OPEN_CURSOR.SQL_TEXT

Start Time

(START_TIME)

Collection start time for the performance data stored in the record

--

time_t

No

All

Agent Collector

User

(USERNAME)

Oracle user name

--

string(30)

No

All

V$SESSION.USERNAME where V$OPEN_CURSOR.SID = V$SESSION.SID