My Oracle Support Banner

Tuxedo To Database - Connections Management (Doc ID 2166765.1)

Last updated on JUNE 08, 2023

Applies to:

Oracle Tuxedo - Version 12.1.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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