Tuxedo Database Connections Test
If the Tuxedo Domain server is unable to connect to the database owing to the absence of adequate connections in the connection pool, then critical server operations may fail. Using this test, you can periodically monitor the usage of each connection pool and promptly detect when a pool runs short of connections. This way, the test provides useful pointers to resizing your connection pools.
Target of the test : A Tuxedo Domain Server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every Group_name:Pool_name auto-discovered from the Tuxedo server being monitored.
Parameter | Description |
---|---|
Test period |
How often should the test be executed. |
Host |
The host for which the test is to be configured. |
Port |
The port at which the specified host listens. The default port is 12345. |
TuxDir |
Specify the full path to the installation directory of the Tuxedo Domain server. For example, while monitoring a Tuxedo server on Windows, your TuxDir can be: E:\oraclehome\tuxedo11gR1 |
AppDir |
Specify the full path to the application directory of the Tuxedo Domain server. For example, while monitoring a Tuxedo server on Windows, your appdir can be: E:\oraclehome\tuxedo11gR1\samples\atmi\simpapp |
TuxConfig |
Each BEA Tuxedo domain is controlled by a configuration file in which installation-dependent parameters are defined. The binary version of this configuration file is called TuxConfig. The TUXCONFIG file may be given any name; the actual name is the device or system filename specified in the TUXCONFIG environment variable. Specify the name of the TuxConfig file here. For example, while monitoring a Tuxedo server on Windows, your TuxConfig can be:E:\oraclehome\tuxedo11gR1\samples\atmi\simpapp\tuxconfig |
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Max connection pool size
|
Indicates the maximum number of connections in this pool. |
Number |
|
Current connection pool size
|
Indicates the current size of this pool. |
Number |
|
Used connections
|
Indicates the number of used connections relative to the size of this pool. |
Number |
Ideally, the value of this measure should be low. |
Free connections
|
Indicates the percentage of unused connections in this pool.
|
Percent |
A high value is desired for this measure. If the value is low, it indicates abnormal usage of the connection pool. You may want to consider resizing the pool, so that sufficient connections are always available in the pool. |