Shared Server Shows High Value for MAX_CONN and Circuits status EOF with SADDR 00

(Doc ID 845757.1)

Last updated on JUNE 19, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1
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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms