| what is the results meaning that select server from v$session ? [message #149812] |
Mon, 05 December 2005 02:20  |
raddisonlee
Messages: 29
Registered: March 2005
|
Junior Member |
|
|
i want to confirm which server mode do my db server runing on !
so i "select server ,username from v$sessions " on client machine
results :
SERVER USERNAME
--------- ------------------------------
DEDICATED SYS
SHARED SYSTEM
DEDICATED SCOTT
NONE SYSTEM
NONE LEE
DEDICATED SYS
DEDICATED LEE
>>>>>>>>>>>>
so i dont sure it meaning on server colum :
shared ,none , what it stands each ????
and how i determine share mode or dedicate mode !!??
thanks
|
|
|
|
| Re: what is the results meaning that select server from v$session ? [message #149837 is a reply to message #149812] |
Mon, 05 December 2005 04:31  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Server Modes:
DEDICATED = Session is connected to a dedicated server process
SHARED = Session is currently connected to a shared server process
NONE = Session in shared mode - not currently connected to a shared server process
PSEUDO = Session marked for kill/ also used for lightweight sessions that use OCI connection pooling
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
