2 Oracle Tuxedo Advanced Performance Pack Configuration
This section describes how to configure various features of Oracle Tuxedo Advanced Performance Pack. All of the features in this product are enabled if the OPTIONS parameter in RESOURES in UBBCONFIG is set to XPP. On Oracle Exalogic and Oracle SPARC SuperCluster platforms, the OPTIONS parameter must be set to EECS.
Some features require further configuration. Such configuration for each feature is described below. Each of these features can be individually disabled if needed. How to disable features individually is describe in the following sections:
- Self-Tuning Lock Mechanism
- Shared Memory Interprocess Communication
- Tightly Coupled Transactions Spanning Domains
- Concurrent Global Transaction Table Lock
- Partial One Phase Read-Only Optimization for RAC
- Single Group Multiple Branches (SGMB)
- Common XID
- XA Transaction Affinity
- Failover/Failback across Database Instances
- Load Balancing across RAC Instances
- FAN Integration
2.1 Self-Tuning Lock Mechanism
Two other optional attributes are supported in UBBCONFIG
*MACHINES section.
-
SPINTUNING_FACTOR - The option
SPINTUNING_FACTORcontrols the tuning target. The default value is 100 which is good enough in most scenarios. It can be changed from 1 to 10000 if necessary. A value of 100 indicates thatSPINCOUNTwill stop tuning as long as less than 1 in 100 attempts to lock result in system level method to get the BB lock and there is sufficient idle CPU. If the number of lock attempts resulting in system level method is higher than 1 and there is sufficient idle CPU time,SPINCOUNTwill be increased. -
SPINTUNING_MINIDLECPU: Specifies the CPU idle time. - The negative impact of the user level method is the extra cost of the CPU. Too many
reties of user level method will cost many CPU time. This option is used to limit the CPU
used by the user level method. The Self-Tuning Lock Mechanism will not increase the
SPINCOUNTwhen the limitation ofSPINTUNING_MINIDLECPUis reached even if the tuning target is not met. On the contrary, theSPINCOUNTwill be decreased when the limitation ofSPINTUNING_MINIDLECPUis broken no matter the tuning target is met or not. For example, given the value of 20, the Self-Tuning Lock Mechanism will control the idle CPU time not less than %20 during the adjustment. The default value is 20.
For more information, see UBBCONFIG(5) and UBBCONFIG(5) Additional Information, Example 2 Self-Tuning Lock Mechanism Configuration, in File Formats, Data Descriptions, MIBs, and System Processes Reference.
You can also set the configuration via TM_MIB. For more information, see TM_MIB(5) in File Formats, Data Descriptions, MIBs, and System Processes Reference.
The following listing shows a UBBCONFIG file example of enabling Self-Tuning Lock Mechanism.
Listing UBBCONFIG File Example of Enabling Self-Tuning Lock Mechanism
*RESOURCES
OPTIONS XPP
...You can disable this feature by specifying the option NO_SPINTUNING in the
UBBCONFIG file.
The following listing shows a UBBCONFIG file example of disabling Self-Tuning Lock Mechanism.
Listing UBBCONFIG File Example of Disabling Self-Tuning Lock Mechanism
*RESOURCES
OPTIONS XPP,NO_SPINTUNING
...Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.2 Shared Memory Interprocess Communication
Another optional attribute is provided in *RESOURCES section.
- SHMQMAXMEM numeric_value
- Specifies the maximum shared memory size (Megabyte) used for message buffers.
The following listing shows a UBBCONFIG file example of enabling Shared Memory Interprocess Communication.
Listing UBBCONFIG File Example of Enabling Shared Memory Interprocess Communication
*RESOURCES
OPTIONS XPP
...You can disable this feature by specifying the option NO_SHMQ in the
UBBCONFIG file.
The following listing shows a UBBCONFIG file example of disabling Shared Memory Interprocess Communication.
Listing UBBCONFIG File Example of Disabling Shared Memory Interprocess Communication
*RESOURCES
OPTIONS XPP,NO_SHMQ
...Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.3 Tightly Coupled Transactions Spanning Domains
The Oracle Tuxedo Advanced Performance Pack includes this feature by default and cannot be disabled.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.4 Concurrent Global Transaction Table Lock
The Oracle Tuxedo Advanced Performance Pack includes this feature by default and cannot be disabled.
Listing Configuration Example of Enabling Concurrent Global Transaction Table Lock by Default
*RESOURCES
OPTIONS XPPParent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.5 Partial One Phase Read-Only Optimization for RAC
The following listing shows a UBBCONFIG file example of enabling Partial One Phase Read-Only Optimization for RAC.
Listing UBBCONFIG File Example of Enabling Partial One Phase Read-Only Optimization for RAC
*RESOURCES
OPTIONS XPP
...You can disable this feature by specifying the option NO_RDONLY1PC in the UBBCONFIG file.
The following listing shows a UBBCONFIG file example of disabling Partial One Phase Read-Only Optimization for RAC.
Listing UBBCONFIG File Example of Disabling Partial One Phase Read-Only Optimization for RAC
*RESOURCES
OPTIONS XPP,NO_RDONLY1PC
...
You can also get/change the configuration via TM_MIB. For more information, see TM_MIB(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.6 Single Group Multiple Branches (SGMB)
The following listing shows a UBBCONFIG file example of enabling SGMB.
Listing Configuration Example of Enabling SGMB by Default
*RESOURCES
OPTIONS XPPYou can disable this feature by specifying the option SINGLETON of
RMOPTIONS in the UBBCONFIG file.
RMOPTIONS {[...|SINGLETON],*}Note:
This option indicates all RAC services being used in the domain are singleton.The following listing shows a UBBCONFIG file example of disabling SGMB.
Listing Configuration Example of Disabling SGMB Explicitly
*RESOURCES
OPTIONS XPP
RMOPTIONS SINGLETONYou can also set this flag when Tuxedo application is inactive through T_DOMAIN class in TM_MIB. For more information, see TM_MIB(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.7 Common XID
The following listing shows a UBBCONFIG file example of enabling Common XID.
Listing Configuration Example of Enabling Common XID by Default
*RESOURCES
OPTIONS XPPYou can disable this feature by specifying the option NO_COMMONXID of
RMOPTIONS in the UBBCONFIG file.
RMOPTIONS {[...|NO_COMMONXID],*}The following listing shows a UBBCONFIG file example of disabling Common XID.
Listing Configuration Example of Disabling Common XID Explicitly
*RESOURCES
OPTIONS XPP
RMOPTIONS NO_COMMONXIDYou can also set this flag when Tuxedo application is inactive through T_DOMAIN class in TM_MIB. For more information, see TM_MIB(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.8 XA Transaction Affinity
The following listing shows a UBBCONFIG file example of enabling XA Transaction Affinity.
Listing Configuration Example of Enabling XA Transaction Affinity by Default
*RESOURCES
OPTIONS XPPYou can disable this feature by specifying the option NO_XAAFFINITY of
RMOPTIONS in the UBBCONFIG file.
RMOPTIONS {[...|NO_XAAFFINITY],*}The following listing shows a UBBCONFIG file example of disabling XA Transaction Affinity.
Listing Configuration Example of Disabling XA Transaction Affinity Explicitly
*RESOURCES
OPTIONS XPP
RMOPTIONS NO_XAAFFINITYYou can also set this flag when Tuxedo application is inactive through T_DOMAIN class in TM_MIB. For more information, see TM_MIB(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.9 Failover/Failback across Database Instances
This feature is implemented using FAN technology. See FAN Integration to enable this technology.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.10 Load Balancing across RAC Instances
This feature is implemented using FAN technology. See FAN Integration to enable this technology.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration
2.11 FAN Integration
The following listing shows a UBBCONFIG file example of enabling FAN Integration.
Listing Configuration Example of Enabling FAN by Default
*RESOURCES
OPTIONS XPPYou can disable this feature by specifying the option NO_FAN of
RMOPTIONS in the UBBCONFIG file.
RMOPTIONS {[...|NO_FAN],*}The following listing shows a UBBCONFIG file example of disabling FAN Integration.
Listing Configuration Example of Disabling FAN Explicitly
*RESOURCES
OPTIONS XPP
RMOPTIONS NO_FANYou can also set this flag when Tuxedo application is inactive through T_DOMAIN class in TM_MIB. For more information, see TM_MIB(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
TMFAN must be configured for Tuxedo to support FAN, specify Tuxedo system server TMFAN in SERVERS section. For more information, see TMFAN(5) in Section 5 - File Formats, Data Descriptions, MIBs, and System Processes Reference.
To support Oracle TAF (Transparent Application Failover) for Tuxedo XA server,
threads=t must be included in OPENINFO in
UBBCONFIG
*GROUPS section.
Parent topic: Oracle Tuxedo Advanced Performance Pack Configuration