My Oracle Support Banner

Shared Server Shows High Value for MAX_CONN and Circuits status EOF with SADDR 00 (Doc ID 845757.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Shared server connection model is being used and a high value is seen for the maximum connections column, MAX_CONN from v$shared_server_monitor view, compared with maximum sessions column, MAX_SESS.

SQL> SELECT MAXIMUM_CONNECTIONS "MAX CONN", MAXIMUM_SESSIONS 
"MAX SESS",SERVERS_STARTED "STARTED", SERVERS_TERMINATED 
"TERMINATED", SERVERS_HIGHWATER "HIGHWATER" FROM 
V$SHARED_SERVER_MONITOR;
.
  MAX CONN   MAX SESS    STARTED TERMINATED  HIGHWATER
---------- ---------- ---------- ---------- ----------
       624        241         34         34         43

At the same time many rows are reported in the v$circuit view, with a value of 00 for the SADDR column.

Small example:

SQL> SELECT SADDR, CIRCUIT, DISPATCHER, SERVER, SUBSTR(QUEUE,1,8) "QUEUE", WAITER FROM V$CIRCUIT;
.
SADDR    CIRCUIT  DISPATCH SERVER   QUEUE     WAITER
-------- -------- -------- -------- --------- --------
00       91621ACC 969E31FC 00       NONE      00
96EB8100 916221EC 969E2C40 00       NONE      00
00       9162290C 969E31FC 00       NONE      00
00       9162302C 969E3D74 969E31FC NONE      00
96F3E020 9162374C 969E2C40 00       NONE      00
00       91623E6C 969E3D74 969E31FC NONE      00
00       9162458C 969E31FC 969E2C40 NONE      00

And showing status of EOF

SQL> select status,count(*) from v$circuit group by status;
.
STATUS             COUNT(*)
---------------- ----------
EOF                    2207
NORMAL                  164

Changes

 

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
Changes
Cause
Solution
References


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