v$session中的server
SERVER TYPE : DEDICATED
The session is established through dedicated connection.
SERVER TYPE : SHARED
The session is established through shared connection.
SERVER TYPE : PSEUDO
the session that issues the ALTER SYSTEM statement to terminate a session waits up to 60 seconds for the session to be terminated; if the operation that cannot be interrupted continues past one minute, the issuer of the ALTER SYSTEM statement receives a message indicating that the session has been "marked" to be terminated. A session marked to be terminated is indicated in V$SESSION with a status of "KILLED" .and a server that is something other than "PSEUDO."
SERVER TYPE : NONE
session is an idle shared server sesssion.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/6906/viewspace-21682/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MTS方式連線V$SESSION中的SERVER狀態SessionServer
- 【SESSION】v$session and v$license 中sessions_current 的區別Session
- Oracle 11g中v$session檢視server列的含義OracleSessionServer
- Oracle V$SESSION中的常用列OracleSession
- 關於v$process與v$session中process的理解Session
- 【Oracle】-【v$session】v$session的SNIPED狀態OracleSession
- v$process和v$session中欄位解釋Session
- V$SESSIONSession
- v$session的解釋Session
- v$session的來源Session
- v$session表的妙用Session
- V$session 表的妙用Session
- v$session中command欄位的含義解析Session
- V$ACTIVE_SESSION_HISTORY 檢視中包含的資訊Session
- v$session中LAST_CALL_ET引數的理解SessionAST
- v$session的blocking_session含義SessionBloC
- session和v$session說明Session
- v session_wait v session_event v system_eventSessionAI
- v$session_event , v$system_event , v$session_waitSessionAI
- 【偵聽】V$session.server = none when using Shared Server/MTS ConfigurationSessionServerNone
- v$session檢視中的sid和serial#研究Session
- [轉] V$session 表的妙用Session
- V$session 表的妙用^_^(轉)Session
- v$session_wait和v$session_event檢視SessionAI
- V$SESSION中的saddr,paddr,taddr 與v$process及v$transaction中欄位的關係Session
- V$SESSION記錄的BLOCKING_SESSION錯誤SessionBloC
- 10.17 V$SESSIONSession
- V$SESSION COMMANDSession
- v$Session詳解Session
- v$session 檢視Session
- v$session command 的含義Session
- V$SESSION的SID&SERIAL#Session
- v$session的一點認知Session
- Connection/Session/Server ProcessesSessionServer
- session bean中的session如何理解？SessionBean
- 幾個檢視 v$mystat v$systata v$sessionSession
- oracle 什麼時候才回收v$session 中status='KILLED'的程式OracleSession
- v$session中的saddr,paddr和taddrSession