SERVER = NONE infers that the connection is via a dispatcher, but the
session is inactive (therefore a shared server is not processing
any work for the session). Once the session is active, then the
SERVER = SHARED,
Andy Tasker
Spirocom Analysts Ltd
Chuck Hamilton wrote in message <3538741d.1589352_at_news.dvol.com>...
>In v$session, what does SERVER = NONE mean? I only see these in my MTS
>environments.
>
>select username, server, status from v$session
>user username is not null
>and rownum < 9;
>
>USERNAME SERVER STATUS
>------------------------------ --------- --------
>QDBA DEDICATED ACTIVE
>PSOFT NONE INACTIVE
>QVCDBA SHARED ACTIVE
>PSOFT DEDICATED INACTIVE
>PSOFT NONE INACTIVE
>PSOFT NONE INACTIVE
>PSOFT NONE INACTIVE
>PSOFT SHARED ACTIVE
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>Hell hath no fury like a hacker spammed!
>
Received on Fri Apr 17 1998 - 12:02:19 CDT
