Tuxedo To Database - Connections Management (Doc ID 2166765.1)

Last updated on JUNE 10, 2024

Applies to:

Goal

Tuxedo 12.1.1
Oracle database (also know as DB)

In production , we are struggling with high number of DB connections to an Oracle database and most of the connection (more than 10K ) are created by Tuxedo and we would like to know some information related to the two points below:

1. Is there any possibility to create DB connection pools? and Please suggest if there is any better solution to handle DB connections?

2. Tuxedo ubb configuration *SERVER section CLOPT parameter using the low/high "-p" option below to spawn instance.  Please recommend/suggest the best practice for production environments?
          productionMSSQ Y -p 1,120:2,1
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.