My Oracle Support Banner

Multiple Inactive SADMIN User Database Connections (Doc ID 498258.1)

Last updated on JULY 09, 2023

Applies to:

Siebel System Software - Version 7.5.3 [16157] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Professional)
Version: 7.8.2 [19213]

This document was previously published as Siebel SR 38-3148536821.

Symptoms

We have begun to see an increasing amount of inactive SADMIN connections which are causing us to hit our peak connections.

We do not want to increase this value on the database any more because of CPU usage and disk I/O on the database server.
Our DBA consistently notices SEVERAL inactive SADMIN connections on the database.

I have been inclined to looking at the Synchronization Manager and modifying the MaxCtxCache parameter with the following command:


Then shutting down and restarting the component.

I have also looked at modifying the ConnIdleTime parameter for the SynchMgr and ObjMgr components.

It still seems as though we are getting a tremendous amount of INACTIVE connections which eventually causes us to max out our connections again.

Is there anything else we need to be taking into consideration?
How can we limit the number of inactive DB connections without impacting the system?

Cause

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
Symptoms
Cause
Solution

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