Hitachi

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


Multi - Threaded Server Interval (PI_PIMT)

Organization of this page

Function

The Multi - Threaded Server Interval (PI_PIMT) record stores performance data, taken at specific intervals, about the multi-thread server (MTS) options.

Default and changeable values

Item

Default value

Changeable

Collection Interval

300

Y

Collection Offset

30

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

ODBC key fields

None

Lifetime

From the creation to the deletion of an Oracle instance in an MTS environment

Record size

Fields

PFM - View name

(PFM - Manager name)

Description

Summary

Format

Delta

Supported version

Data source

Avg Queue Wait

(QUEUES_AVERAGE_WAIT)

Average wait time per item in hundredths of a second#2

AVG

double

No

All

V$QUEUE.WAIT / V$QUEUE.TOTALQ

Circuits

(CIRCUITS)

Number of circuits#2

AVG

ulong

No

All

COUNT(V$CIRCUIT)

Dispatchers

(DISPATCHERS)

Number of dispatchers#2

AVG

ulong

No

All

COUNT(V$DISPATCHER)

Dispatchers Busy

(DISPATCHERS_BUSY)

Total busy time of all dispatchers in hundredths of a second#2

AVG

double

Yes

All

SUM(V$DISPATCHER.BUSY)

Dispatchers Busy %

(DISPATCHERS_PERCENT_BUSY)

Percentage of the time all dispatchers were busy#2

AVG

double

No

All

(SUM(V$DISPATCHER.BUSY) / (SUM(V$DISPATCHER.IDLE) + SUM(V$DISPATCHER.BUSY))) * 100

Dispatchers Idle

(DISPATCHERS_IDLE)

Total idle time of all dispatchers in hundredths of a second#2

AVG

double

Yes

All

SUM(V$DISPATCHER.IDLE)

Dispatchers Idle %

(DISPATCHERS_PERCENT_IDLE)

Percentage of the time all dispatchers were idle#2

AVG

double

No

All

(SUM(V$DISPATCHER.IDLE) / (SUM(V$DISPATCHER.IDLE) + SUM(V$DISPATCHER.BUSY))) * 100

Dispatchers Messages

(DISPATCHERS_MESSAGES)

Total number of messages processed by all dispatchers#2

AVG

double

Yes

All

SUM(V$DISPATCHER.MESSAGES)

Items Queued

(QUEUES_QUEUED)

Total number of items currently in all queues#2

AVG

double

No

All

SUM(V$QUEUE.QUEUED)

MTS Max Servers %

(PERCENT_MTS_MAX_SERVERS)

Ratio (as a percent) of the number of MTS servers to the MTS_MAX_SERVERS parameter value in the init.ora file. The value is always 0. #2

AVG

double

No

All

(COUNT(V$SHARED_SERVER) / init.ora MTS_MAX_SERVERS) * 100

MTS Servers Highwater

(SERVERS_HIGHWATER)

Maximum number of multi-thread servers (MTS) that were running at any one time since the instance started#2

HILO

long

No

All

  • Which does not have any locally managed temporary tablespaces:

    V$MTS.SERVERS_HIGHWATER

  • Which has locally managed temporary tablespaces:

    V$SHARED_SERVER_MONITOR.SERVERS_HIGHWATER

MTS Servers Started

(SERVERS_STARTED)

Total number of multithread servers (MTS) since the instance started (this value does not include multi-thread servers that started during startup processing)#2

AVG

long

Yes

All

  • Which does not have any locally managed temporary tablespaces:

    V$MTS.SERVERS_STARTED

  • Which has locally managed temporary tablespaces:

    V$SHARED_SERVER_MONITOR.SERVERS_STARTED

MTS Servers Terminated

(SERVERS_TERMINATED)

Total number of multithread servers (MTS) that were terminated by Oracle since the instance started#2

AVG

double

Yes

All

  • Which does not have any locally managed temporary tablespaces:

    V$MTS.SERVERS_TERMINATED

  • Which has locally managed temporary tablespaces:

    V$SHARED_SERVER_MONITOR.SERVERS_TERMINATED

PQS Busy

(PQS_BUSY)

Length of time all parallel query servers were busy (in minutes)#2

AVG

double

Yes

All

SUM(V$PQ_SLAVE.BUSY_TIME_TOTAL)

PQS Busy %

(PQS_PERCENT_BUSY)

Percentage of the time all parallel query servers were busy#2

AVG

double

No

All

(SUM(V$PQ_SLAVE.BUSY_TIME_TOTAL) / (SUM(V$PQ_SLAVE.IDLE_TIME_TOTAL) + SUM(V$PQ_SLAVE.BUSY_TIME_TOTAL))) * 100

PQS CPU

(PQS_CPU)

CPU time used by all parallel query servers to process SQL statements#2

AVG

double

Yes

All

SUM(V$PQ_SLAVE.CPU_SECS_TOTAL)

PQS Idle

(PQS_IDLE)

Length of time all parallel query servers were idle (in minutes)#2

AVG

double

Yes

All

SUM(V$PQ_SLAVE.IDLE_TIME_TOTAL)

PQS Idle %

(PQS_PERCENT_IDLE)

Percentage of the time all parallel query servers were idle#2

AVG

double

No

All

(SUM(V$PQ_SLAVE.IDLE_TIME_TOTAL) / (SUM(V$PQ_SLAVE.IDLE_TIME_TOTAL) + SUM(V$PQ_SLAVE.BUSY_TIME_TOTAL))) * 100

PQS Msgs Rcvd

(PQS_MSGS_RCVD)

Total number of messages received by all parallel query servers#2

AVG

double

Yes

All

SUM(V$PQ_SLAVE.MSGS_ RCVD_TOTAL)

PQS Msgs Sent

(PQS_MSGS_SENT)

Total number of messages sent by all parallel query servers#2

AVG

double

Yes

All

SUM(V$PQ_SLAVE.MSGS_SENT_TOTAL)

PQS Sessions

(PQS_SESSIONS)

Number of sessions being used by parallel query servers#2

AVG

ulong

Yes

All

SUM(V$PQ_SLAVE.SESSIONS)

Parallel Query Servers

(PARALLEL_QUERY_SERVERS)

Number of parallel query servers#2

AVG

long

No

All

COUNT(V$PQ_SLAVE)

Queues

(QUEUES)

Number of queues#2

AVG

ulong

No

All

COUNT(V$QUEUE)

Record Time

(RECORD_TIME)

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

COPY

time_t

No

All

Agent Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PIMT)#1

COPY

string(4)

No

All

Agent Collector

Shared Server Idle %

(SHARED_SERVERS_PERCENT_IDLE)

Percentage of the time during which all shared servers were idle#2

AVG

double

No

All

(V$SHARED_SERVER.IDLE / (V$SHARED_SERVER.IDLE + $SHARED_SERVER.BUSY)) * 100

Shared Servers

(SHARED_SERVERS)

Number of shared servers#2

AVG

long

No

All

COUNT(V$SHARED_SERVER)

Shared Servers Busy

(SHARED_SERVERS_BUSY)

Total length of time during which all shared servers were busy, in hundredths of a second#2

AVG

double

Yes

All

SUM(V$SHARED_SERVER.BUSY)

Shared Servers Busy %

(SHARED_SERVERS_PERCENT_BUSY)

Percentage of the time during which all shared servers were busy#2

AVG

double

No

All

(V$SHARED_SERVER.BUSY / (V$SHARED_SERVER.IDLE + V$SHARED_SERVER.BUSY)) * 100

Shared Servers Idle

(SHARED_SERVERS_IDLE)

Total length of time during which all shared servers were idle, in hundredths of a second#2

AVG

double

Yes

All

SUM(V$SHARED_SERVER.IDLE)

Shared Servers Messages

(SHARED_SERVERS_MESSAGES)

Total number of messages processed by all shared servers#2

AVG

double

Yes

All

SUM(V$SHARED_SERVER.MESSAGES)

Start Time

(START_TIME)

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

COPY

time_t

No

All

Agent Collector

Total ItemsQueued

(QUEUES_TOTAL_QUEUED)

Total number of items in all queues#2

AVG

double

Yes

All

SUM(V$QUEUE.TOTALQ)

Total Queue Wait

(QUEUES_WAIT)

Total length of time all items were queued in hundredths of a second#2

AVG

double

Yes

All

SUM(V$QUEUE.WAIT)