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
-
Fixed part: 1,274 bytes
-
Variable part: 0 bytes
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 |
|
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 |
|
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 |
|
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) |