Why v$session.server is NONE when server is configured using shared server?
Hi I configured the following
alter system set dispatchers='(PROTOCOL=TCP) (SERVICE=tomkyte) (CON=950) (SESSIONS=4000) (POOL=on)' ;
I make altogether 3 connections as user SCOTT.
when I did a query on v$circuit
select dispatcher, circuit, server, status from v$circuit;
results:
DISPATCH CIRCUIT SERVER STATUS
-------- -------- -------- ----------------
5E61A6EC 5C588934 00 NORMAL
5E61A6EC 5C589040 00 NORMAL
5E61A6EC 5C58974C 00 NORMAL
I can see the three connections.
but when I did a query on v$session.SERVER, it is indicated as NONE.
exec :v_username='SCOTT';
SELECT a.sid,a.serial#, a.server,a.username, a.osuser, b.spid
FROM v$session a, v$process b
WHERE a.paddr = b.addr
AND a.username IS NOT null
and a.username=:v_username;
results:
SID SERIAL# SERV USERN OSUSER SPID
---------- ---------- ---- ----- ------ ------------
159 719 NONE SCOTT oracle 13881
152 126 NONE SCOTT oracle 13881
130 1156 NONE SCOTT oracle 13881
How come all v$SESSION.SERVER is indicated as NONE?
thanks