Originally posted by burzinmk
Hi experts,

What is the difference between "dedicated","shared","none","pseudo" of the "server" attribute of the view v$session ? When I am using a shared server connection, the "server" attribute of the v$session view displays "none". When would this become "shared" and what is the significance of "pseudo"?
When you kill a session, the "server" column changes to "pseudo".

v$session.server always shows the type of connection made to the dataabase server. To make a SHARED server you need to set few parameters in init.ora.

You can always make a DEDICATED connection to shared shared. The type of connection which you need to make has to be specify in tnsnames.ora. All background processes make a DEDICATED connection to database.

F.ex
Code:
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SID = ORCL)
    )
  )

ORCL2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = ORCL)
    )
  )
Above two entries points to same database with different connection type. So in this case v$session.server will show "DEDICATED" and "SHARED" status resp...

Refer to http://otn.oracle.com/docs/products/...proc.htm#13880
for setting up shared server.

HTH

Sameer