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 laterInformation 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
"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
.
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
.
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 |