To update an instance environment, check the name of the instance that you want to update, and change the instance information. The instance information is set from a PFM - RM host.
Before you change an information item, check the following table. For details about Oracle instance information, see your Oracle documentation.
Table 2-29 PFM - RM for Oracle instance information
Item | Description | Specifiable value | Default |
---|---|---|---|
oracle_sid | The value of this item can be updated. ID of the monitored Oracle system (same value as the ORACLE_SID environment variable). | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_home#1 | The value of this item can be updated. Oracle home folder of Oracle client used by PFM - RM for Oracle (same value as the ORACLE_HOME environment variable). #2 | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_version#1 | The value of this item can be updated. Version number of Oracle Client used by PFM - RM for Oracle. |
| Previous value |
oracle_user#3 | The value of this item can be updated. Account for monitoring Oracle (for details about accounts that can be specified, and the required privileges, see 2.1.4(2) Create an Oracle account to be used in PFM - RM for Oracle). | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_passwd#3,#4 | The value of this item can be updated. Specify the password for the account specified in oracle_user. | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
net_service_name#1,#5 | The value of this item can be updated. Net service name of the monitored database. For details about the net service name of the monitored database, see the Oracle documentation. | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
retry_time | The value of this item can be updated. The number of seconds for which reconnection is attempted when an authentication error is output during Oracle connection. If an authentication error occurs after the specified period has passed, the PFM - RM for Oracle service stops. When the value is 0, the PFM - RM for Oracle service stops without retrying to re-establish connection in the event of an authentication error. This item is enabled when startup_always is N. The specification of this item is ignored when startup_always is Y. | 0 to 600 (in seconds). | Previous value |
log_path | The value of this item can be updated. Specify the absolute path name of the agent log output folder. | A character string of 245 or fewer bytes that does not include the following characters:
| Previous value |
log_size | The value of this item can be updated. Specify the maximum size of each agent log file. | 1 to 32 (in kilobytes). 16 or a greater value is recommended. | Previous value |
timeout | The value of this item can be updated. The timeout period for Oracle access during a query. | 0, or 10 to 3600 (in seconds). When 0 is specified, timeout monitoring is not performed. When a value from 1 to 9 is specified, it is changed to 10 at runtime. | Previous value |
sql_option#6 | The value of this item can be updated. When Y is specified, information about the following items#5 is not collected for PI_PIDB and PD_PDTS records, and the value specified by 0 or numeric_10 is set. | { Y | N } | Previous value |
numeric_10 | The value of this item can be updated. When sql_option is set to Y, the value specified is set for items for which information is not collected. If sql_option is set to N, this specification is disregarded. | 0 to 99999. Note that if the value specified exceeds the maximum value for the data format of the set field (32767 for short and 65535 for ushort), the maximum value for the data format is set.#7 | Previous value |
startup_always | The value of this item can be updated. PFM - RM for Oracle may stop due to an Oracle connection error, such as when the monitored Oracle is still starting up when PFM - RM for Oracle starts up. If Y is specified, start processing continues even if a connection error occurs. If N is specified, start processing will stop if an error occurs. | { Y | N } | Previous value |
localtemp_option#8 | The value of this item can be updated. Option for switching the display of the free space of the locally managed temporary tablespace of PD_PDDB, PI_PIDB, PD_PDDF, PI_PIDF, PD_PDTF, PD_PDTS, and PD_PCTS records. If Y is specified, display the size of the free space. If N is specified, display the size of the unallocated space. | { Y | N } | Previous value |
undospace_option#9 | The value of this item can be updated. Option for switching how the value displayed as the free space in the UNDO tablespace of the PD_PDDB, PI_PIDB, PD_PDDF, PI_PIDF, PD_PDTS, and PD_PCTS records is determined. If N is specified, the size of the unallocated space is displayed. If Y is specified, the size of the free space is displayed. | { Y | N } | Previous value |
nls_lang#10 | The value of this item can be updated. Option for specifying the character encoding used for communication between PFM - RM for Oracle and Oracle Database. | Character code set:
| Previous value |
oracle_home\network\admin
Table 2-30 Record names and the values specified for numeric_10 (updating instance information)
Record Name | PFM - View name | Value specified for numeric_10 |
---|---|---|
PD_PDTS | Segments | Enabled |
Extents | Enabled | |
PI_PIDB | DB Files % | Enabled |
Log Files % | Enabled | |
NextAlloc Fails | Enabled | |
Tablespaces | Enabled | |
Rollback Segments | Enabled | |
Rollback Segments Trans | Enabled | |
Blocks | Enabled | |
Segments | Enabled | |
Extents | Enabled | |
Free Mbytes | Enabled | |
Overextended | Enabled | |
High Max Extent | Enabled | |
Datafiles | Enabled | |
Mbytes | Enabled | |
Free Extents | Enabled | |
Free% | Enabled | |
Free Change | Enabled | |
Write% | Enabled | |
Write/sec | Enabled | |
Redo Files | Enabled | |
Links | Enabled | |
Links Logged On | Enabled | |
Links In Tran | Enabled | |
Links Open Cursors | Enabled | |
Used Change | Enabled | |
Used Mbytes | Enabled | |
Rollback Segments Hit% | Enabled | |
Sort Segments | Enabled | |
Sorting Users | Enabled | |
Physical Blocks Read | Always set to 0 because it is a delta item. | |
Physical Blocks Written | Always set to 0 because it is a delta item. | |
Physical Reads | Always set to 0 because it is a delta item. | |
Physical Writes | Always set to 0 because it is a delta item. |
Record name | Field name |
---|---|
Data File (PD_PDDF) | Free % |
Free Mbytes | |
Used Mbytes | |
Data File Interval (PI_PIDF) | Free % |
Free Change | |
Free Mbytes | |
Used Change | |
Used Mbytes | |
Database (PD_PDDB) | Free % |
Free Mbytes | |
Used Mbytes | |
Database Interval (PI_PIDB) | Free % |
Free Change | |
Free Mbytes | |
Used Change | |
Used Mbytes | |
Tablespace (PD_PDTS) | Free % |
Free Mbytes | |
Used Mbytes | |
Collection Tablespace 2 (PD_PCTS) | Free Mbytes |
Figure 2-11 Relationship between data and the setting values
OS language of PFM - RM for Oracle installed | NLS_CHARACTERSET of the monitored Oracle (Database character set) | nls_lang instance information (this item) |
---|---|---|
Japanese | JA16SJISTILDE | AMERICAN_AMERICA.JA16SJISTILDE or AMERICAN_AMERICA.US7ASCII# |
JA16SJIS | ||
other | AMERICAN_AMERICA.US7ASCII# | |
Simplified-Chinese | ZHS16GBK | AMERICAN_AMERICA.GB18030 or AMERICAN_AMERICA.US7ASCII# |
AL32UTF8 | ||
other | AMERICAN_AMERICA.US7ASCII# | |
other language | notdependent | AMERICAN_AMERICA.US7ASCII# |
Recode name | Field name | Filed size (unit: bytes) |
---|---|---|
Parameter Values(PD_PDP) | Value | 512 |
SQL Text(PD_PDSQ) | Explain Plan | 30,000 |
SQL Text | 30,000 |
Use the jpcconf inst list command to check the instance name. To update an instance environment, use the jpcconf inst setup command.
Updating an instance environment involves the steps described below. To update multiple instance environments, repeat the procedure for each instance environment.
To update an instance environment:
jpcconf inst list -key RMOracle
jpcconf inst setup -key RMOracle -inst SDC
For details about commands, see the chapter on commands in the manual Job Management Partner 1/Performance Management Reference.
Table 2-31 PFM - RM for Oracle instance information
Item | Description | Specifiable value | Default |
---|---|---|---|
oracle_sid | The value of this item can be updated. ID of the monitored Oracle system (same value as the ORACLE_SID environment variable). | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_home#1 | The value of this item can be updated. The value of this item can be updated. Oracle home folder of Oracle client used by PFM - RM for Oracle (same value as the ORACLE_HOME environment variable). #1 | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_version#1 | The value of this item can be updated. Version number of Oracle Client used by PFM - RM for Oracle. |
| Previous value |
oracle_user#3 | The value of this item can be updated. Account for monitoring Oracle (for details about accounts that can be specified, and the required privileges, see 2.2.4(3) Create an Oracle account to be used in PFM - RM for Oracle).#2 | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
oracle_passwd#3,#4 | The value of this item can be updated. Specify the password for the account specified in oracle_user. | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
net_service_name#1.#5 | The value of this item can be updated. Net service name of the monitored database. For details about the net service name of the monitored database, see the Oracle documentation. | A character string of 255 or fewer bytes that does not include the following characters:
| Previous value |
log_path#6 | The value of this item can be updated. Specify the absolute path name of the agent log output folder. | A character string of 245 or fewer bytes that does not include the following characters:
| Previous value |
log_size | The value of this item can be updated. Specify the maximum size of each agent log file. | 1 to 32 (in kilobytes). 16 or a greater value is recommended. | Previous value |
timeout | The value of this item can be updated. The timeout period for Oracle access during a query. | 0, or 10 to 3600 (in seconds). When 0 is specified, timeout monitoring is not performed. When a value from 1 to 9 is specified, it is changed to 10 at runtime. | Previous value |
sql_option#7 | The value of this item can be updated. When Y is specified, information about the following items#6 is not collected for PI_PIDB and PD_PDTS records, and the value specified by 0 or numeric_10 is set. | { Y | N } | Previous value |
numeric_10 | The value of this item can be updated. When sql_option is set to Y, the value specified is set for items for which information is not collected. If sql_option is set to N, this specification is disregarded. | 0 to 99999. Note that if the value specified exceeds the maximum value for the data format of the set field (32767 for short and 65535 for ushort), the maximum value for the data format is set.#7 | Previous value |
startup_always | The value of this item can be updated. PFM - RM for Oracle may stop due to an Oracle connection error, such as when the monitored Oracle is still starting up when PFM - RM for Oracle starts up. If Y is specified, start processing continues even if a connection error occurs. If N is specified, start processing will stop if an error occurs. | { Y | N } | Previous value |
localtemp_option#9 | The value of this item can be updated. Option for switching the display of the free space of the locally managed temporary tablespace of PD_PDDB, PI_PIDB, PD_PDDF, PI_PIDF, PD_PDTF, PD_PDTS, and PD_PCTS records. If Y is specified, display the size of the free space. If N is specified, display the size of the unallocated space. | { Y | N } | Previous value |
nls_lang#10 | The value of this item can be updated. Option for specifying the character encoding used for communication between PFM - RM for Oracle and Oracle Database. | Character code set: According to LANG of the OS when at the start time of the PFM - RM for Oracle.
| Previous value |
undospace_option#11 | The value of this item can be updated. Option for switching how the value displayed as the free space in the UNDO tablespace of the PD_PDDB, PI_PIDB, PD_PDDF, PI_PIDF, PD_PDTS, and PD_PCTS records is determined. If N is specified, the size of the unallocated space is displayed. If Y is specified, the size of the free space is displayed. | { Y | N } | Previous value |
oracle_home/network/admin
#6
Manually save the old path information in a file as history data, since the information is not saved automatically. You may need to acquire the agent log information from the old directory if a problem occurs.
#7
To obtain each piece of Oracle segment-related information, PFM - RM for Oracle searches Oracle's static data dictionary views DBA_SEGMENTS. If a large number of segments (more than hundreds of thousands) exist for Oracle, information collection requires a significant amount of time. As such, when a large number of segments exist, and the information listed in the following table no longer needs to be collected, set the sql_option to Y during operation.
Table 2-32 Record names and the values specified for numeric_10 (updating instance information)
Record Name | PFM - View name | Value specified for numeric_10 |
---|---|---|
PD_PDTS | Segments | Enabled |
Extents | Enabled | |
PI_PIDB | DB Files % | Enabled |
Log Files % | Enabled | |
NextAlloc Fails | Enabled | |
Tablespaces | Enabled | |
Rollback Segments | Enabled | |
Rollback Segments Trans | Enabled | |
Blocks | Enabled | |
Segments | Enabled | |
Extents | Enabled | |
Free Mbytes | Enabled | |
Overextended | Enabled | |
High Max Extent | Enabled | |
Datafiles | Enabled | |
Mbytes | Enabled | |
Free Extents | Enabled | |
Free% | Enabled | |
Free Change | Enabled | |
Write% | Enabled | |
Write/sec | Enabled | |
Redo Files | Enabled | |
Links | Enabled | |
Links Logged On | Enabled | |
Links In Tran | Enabled | |
Links Open Cursors | Enabled | |
Used Change | Enabled | |
Used Mbytes | Enabled | |
Rollback Segments Hit% | Enabled | |
Sort Segments | Enabled | |
Sorting Users | Enabled | |
Physical Blocks Read | Always set to 0 because it is a delta item. | |
Physical Blocks Written | Always set to 0 because it is a delta item. | |
Physical Reads | Always set to 0 because it is a delta item. | |
Physical Writes | Always set to 0 because it is a delta item. |
Figure 2-12 Relationship between data and the setting values
LANG environment variable of at the start time of PFM - RM for Oracle | nls_lang instance information (this item) |
---|---|
ja_JP.UTF-8, ja_JP.utf-8, zh_CN.UTF-8, zh_CN.utf8 | AMERICAN_AMERICA.AL32UTF8 or AMERICAN_AMERICA.US7ASCII# |
zh_CN.gb18030 | AMERICAN_AMERICA.ZHS32GB18030 or AMERICAN_AMERICA.US7ASCII# |
other LANG | AMERICAN_AMERICA.US7ASCII# |
Record name | Field name | Field size (Unit: bytes) |
---|---|---|
Collection Instance 2 (PD_PCI) | Host | 30 |
Data File (PD_PDDF) | File Name | 255 |
Data File Interval (PI_PIDF) | File Name | 255 |
Instance (PD_PDI) | Host | 30 |
Minimum Data File Interval 2 (PI_PMDF) | File Name | 255 |
Parameter Values (PD_PDP) | Value | 512 |
SQL Text (PD_PDSQ) | Explain Plan | 30000 |
SQL Text | 30000 |
Record name | Field name | Field size (Unit: bytes) |
---|---|---|
Collection Tablespace 2(PD_PCTS) | Tablespace Name | 30 |
Data File(PD_PDDF) | File Name | 255 |
Tablespace Name | 30 | |
Data File Interval(PI_PIDF) | File Name | 255 |
Tablespace Name | 30 | |
Database(PD_PDDB) | DB Name | 9 |
Database Interval(PI_PIDB) | DB Name | 9 |
Instance(PD_PDI) | Host | 30 |
Lock Waiters(PD_PDLW) | Holding User | 30 |
Waiting User | 30 | |
Minimum Database Interval 2(PI_PMDB) | DB Name | 9 |
Minimum Data File Interval 2(PI_PMDF) | File Name | 513 |
Minimum Tablespace Interval 2(PI_PMTS) | Tablespace Name | 30 |
Open Cursor(PD_PDOC) | Program | 48 |
SQL Text | 60 | |
Parameter Values(PD_PDP) | Value | 512 |
Session Detail(PD_PDS) | Machine | 64 |
Module | 48 | |
OS User | 30 | |
Program | 64 | |
Schema Name | 30 | |
User | 30 | |
Session I/O Interval(PI_PIIO) | User | 30 |
Session Statistics Summary(PD_PDS2) | Program | 48 |
User | 30 | |
SQL Text(PD_PDSQ) | Explain Plan | 30,000 |
SQL Text | 30,000 | |
Tablespace Flagmentation(PD_PDTF) | Tablespace Name | 30 |
Tablespace Interval(PI_PITS) | Tablespace Name | 30 |
Tablespace(PD_PDTS) | Tablespace Name | 30 |
Transaction(PD_PDTR) | User | 30 |
Tranasction Lock(PD_PDTL) | Object Name | 30 |
Owner | 30 | |
User | 30 |
Record name | Field name |
---|---|
Data File (PD_PDDF) | Free % |
Free Mbytes | |
Used Mbytes | |
Data File Interval (PI_PIDF) | Free % |
Free Change | |
Free Mbytes | |
Used Change | |
Used Mbytes | |
Database (PD_PDDB) | Free % |
Free Mbytes | |
Used Mbytes | |
Database Interval (PI_PIDB) | Free % |
Free Change | |
Free Mbytes | |
Used Change | |
Used Mbytes | |
Tablespace (PD_PDTS) | Free % |
Free Mbytes | |
Used Mbytes | |
Collection Tablespace 2 (PD_PCTS) | Free Mbytes |
Use the jpcconf inst list command to check the instance name. To update an instance environment, use the jpcconf inst setup command.
Updating an instance environment involves the steps described below. To update multiple instance environments, repeat the procedure for each instance environment.
To update an instance environment:
jpcconf inst list -key RMOracle
jpcconf inst setup -key RMOracle -inst SDC
For details about commands, see the chapter on commands in the manual Job Management Partner 1/Performance Management Reference.