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說明Session
- 10.17 V$SESSIONSession
- V$SESSION COMMANDSession
- v$Session詳解Session
- 10.18 V$SESSION_BLOCKERSSessionBloC
- 10.21 V$SESSION_EVENTSession
- 10.25 V$SESSION_WAITSessionAI
- v$session - 你看到的event真的是session當前的等待事件麼?Session事件
- oracle 什麼時候才回收v$session 中status='KILLED'的程式OracleSession
- 10.27 V$SESSION_WAIT_HISTORYSessionAI
- 10.26 V$SESSION_WAIT_CLASSSessionAI
- [20221023]v$session_longops.txtSessionGo
- V$ACTIVE_SESSION_HISTORY檢視的使用Session
- Tomcat中的session實現TomcatSession
- Tomcat 中的 Session 和 CookieTomcatSessionCookie
- hibernate中的no session問題Session
- [20211019]V$DETACHED_SESSION檢視.txtSession
- Server Tomcat v9.0 Server at localhost failed to start.ServerTomcatlocalhostAI
- Django中的session常見配置DjangoSession
- flask框架中的cookie和sessionFlask框架CookieSession
- 利用v$session_longops監控長操作SessionGo
- 為什麼資料庫中大量的server process沒有對應的session?資料庫ServerSession
- 關於解決Server Tomcat v9.0 Server at localhost failed to start的問題ServerTomcatlocalhostAI
- 第74節:Java中的Cookie和SessionJavaCookieSession
- PG14中的idle_session_timeoutSession
- [20220120]探究v$session.SQL_EXEC_ID在共享池.txtSessionSQL
- oracle中的processes,session,transaction引數詳解OracleSession
- Windows Server 2016-Hyper-V HNV 新增功能WindowsServer
- SQL Server 中的 ACID 屬性SQLServer
- SQL Server 2008中Analysis Services的新特性——深入SQL Server 2008SQLServer
- Cloud Foundry Session Affinity(Sticky Session)的實現CloudSession
- session檢視中wait_timeSessionAI
- 從session中獲取資料Session
- [20230226]探究v$session.SQL_EXEC_ID在共享池(windows).txtSessionSQLWindows
- http中session和cookie的區別和關係HTTPSessionCookie
- OB運維 | 連線 kill 中的 session_id運維Session
- keyclaok~keycloak存到cookie中的值和session_stateCookieSession
- HTTP 錯誤 500.19 - Internal Server Error v4.0.30319HTTPServerError