3.4.3 Cancellation facility for Oracle access during record collection
The maximum time for accessing Oracle can be set as a timeout value, for the time it takes to collect 1 record.
When record data is collected while Oracle and the machine are experiencing heavy load, it may take a significant amount of time to perform record collection, depending on the amount of data collected. In this case, PFM - Agent for Oracle requests may impact Oracle operation. As such, a timeout value can be set to cancel requests from PFM - Agent for Oracle to Oracle, to prevent impact on Oracle operation.
Record collection is performed in the following order for each record:
-
Oracle is accessed
-
Data is written to the Store database
However, when a timeout value is set, and a timeout occurs during Oracle access, collection for that record is canceled.
This facility is implemented using the OCIBreak function of the Oracle OCI (Oracle Call Interface).
The timeout value can be set as follows:
-
During instance environment setup by using the jpcconf inst setup command
-
By changing the TIMEOUT property for the Agent Collector service, in the PFM - Web Console GUI
The values that can be set are 0, or anything from 10 to 3,600 (in seconds). If 0 is specified, this facility is not used. Out-of-range values will be disregarded. 0 is set as the default.
The following table lists the values that can be entered as timeout values, for each setting method.
Setting method |
Value input |
||||
---|---|---|---|---|---|
-1 or less |
0 |
1 to 9 |
10 to 3,600 |
3,601 or more |
|
Setting/update from the jpcconf inst setup command |
Input error (cannot be input) |
Yes |
Yes, but replaced on restart |
Yes |
Input error (cannot be input) |
Change from PFM - Web Console |
Yes, but not updated |
Yes |
Yes, but not updated |
Yes |
Yes, but not updated |
- Legend:
-
Yes: Can be input.
Yes, but replaced on restart: Can be input, but replaced with 10 when PFM - Agent for Oracle is restarted. A KAVF12630-W message is output to the common message log.
Yes, but not updated: Can be input, but cannot be updated. A KAVF12630-W message is output to the common message log.
- Note:
-
Set the timeout value according to the time needed to collect records during heavy load (peak time).
For details about the timeout values set by the jpcconf inst setup command, see 2.1.4(4) Set up an instance environment.
Note that the following records are not subject to cancellation:
-
Instance Availability (PD_PDIA)
-
Server Status(PD_STAT)
-
SQL*Net Listener(PD_PDNL)
-
SQL*Net Listeners(PD_PDLS)
When a timeout occurs, the following message is output to the common log (agtoinf0x.log) of the agent log.
KAVF12636-I The cancellation of the record collection (record-name) by the time-out was accepted.
Note that when records are not collected due to cancellation, a KAVF12401-W message is output to the common message log.
When a collection of multiple records, such as historical data, is performed at the same time, even if a timeout occurs for a single record, collection of other records is not performed.
- Note:
-
Since PFM - Agent for Oracle uses the OCI (Oracle Call Interface), the time required for actual cancellation depends on the processing time for OCIBreak(). As such, cancellation may not happen instantly.
In the following cases, a record collection is not canceled even when a cancellation request occurs due to a timeout:
-
When a timeout occurs while a collection sequence is being moved to be written to the Store database.
-
Cancellation occurs due to timeout while Oracle access is terminating, in which case the KAVF12636-I message is output to the log file, but record collection is performed normally.