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:
This problem can occur on any platform.


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.

---------- ---------- ---------- ---------- ----------
       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:

-------- -------- -------- -------- --------- --------
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


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