Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why v$session.server is NONE when server is configured using shared server?

dbanoob4everNov 29 2008 — edited Dec 5 2008
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2009
Added on Nov 29 2008
11 comments
4,302 views