Oracle Database Discussions

Hi
See below my dispatcher settings.

I think, this setting means,
I want 3 TCP/IP dispatcher to handle a maximum of 2 concurrent connections
and a maximum of 3 sessions per dispatcher.

Here comes my question,
See below, The query to find # of concurrent connection shows all the 9 sessions,
I invoked using the shared server. This is confusing to me w.r.t dispatcher settings,
which says, I can have only maximum of 2 concurrent connections.

How do I test and see the # of concurrent connections I have on the database ?
Seems to me, the query I have to identify the concurrent connection is incorrect.
Please help.

Let me know, if you have any questions.


-- dispatcher settings.
======================

select * from v$parameter where name like '%dispatc%' order by name;

797 dispatchers 2 (PROTOCOL=tcp)(DISPATCHERS=3)(POOL=on)(TICK=1) (CONNECTIONS=2)(SESSIONS=3) (PROTOCOL=tcp)(DISPATCHERS=3)(POOL=on)(TICK=1) (CONNECTIONS=2)(SESSIONS=3)
800 max_dispatchers 3 (null) (null)


-- query to find # of concurrent connections.
==============================================

select sid,serial#,username,server,program, status from v$session
where username is not null order by sid, server;


133 7 SYSTEM NONE sqlplus.exe INACTIVE
134 170 SYSTEM NONE sqlplus.exe INACTIVE
136 2 SYSTEM NONE sqlplus.exe INACTIVE
137 14 SYSTEM NONE sqlplus.exe INACTIVE
138 7 SYSTEM NONE sqlplus.exe INACTIVE
139 46 SYSTEM DEDICATED sqlplus.exe INACTIVE
140 135 SYSTEM NONE sqlplus.exe INACTIVE
141 162 SYSTEM NONE sqlplus.exe INACTIVE
144 100 SYSTEM NONE sqlplus.exe INACTIVE
145 24 SYSTEM NONE sqlplus.exe INACTIVE
155 22 SYSTEM DEDICATED SQL Developer ACTIVE
156 59 SYSTEM DEDICATED SQL Developer INACTIVE
158 72 SCOTT DEDICATED ORACLE.EXE (J001) ACTIVE