Connection/Session/Server Processes
三者之間的區別.
Connection是Oracle例項和使用者程式之間的通訊通道.
Session是使用者透過使用者程式與Oracle例項建立的一個特定的連線.比如,使用者啟動sql*plus,輸入有效的使用者名稱和密碼,就可以與Oracle例項建立一個Session.
Oracle建立Server Processes用於控制/處理連線到Oracle例項的使用者程式請求.
tom kyte的解釋:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/6906/viewspace-21726/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- A discussion of Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processesMITSession
- Dedicated and Shared Server ProcessesServer
- Server Processes (112)Server
- oracle中的processes,session,transaction引數OracleSession
- Shared Server Processes (Snnn) (131)Server
- connection和session的關係Session
- oracle中的processes,session,transaction引數詳解OracleSession
- hibernate的session.connection被session.dowork()替代Session
- Keep processes running in the background and even after SSH session disconnectsSession
- oracle中引數session和 processes的設定(轉)OracleSession
- 如何區分 Connection、Thread和SessionthreadSession
- process/session/connection的一些問題Session
- connection session process的聯絡與區別Session
- MongoDB mongoimport 報錯:lost connection to serverMongoDBImportServer
- Xlib: connection to ":0.0" refused by server(openSUSE)Server
- v$session中的serverSessionServer
- Scheduler&Task&Worker&Thread&Request&Session&Connection OF MSSQLthreadSessionSQL
- ascp: Failed to open TCP connection for SSH, exiting. Session Stop (Error: Failed to open TCP connection for SSH)AITCPSessionError
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- Xlib: connection to ":0.0" refused by server 問題Server
- db_writer_processes-log_archive_max_processesHive
- Lost connection to MySQL server at 'reading authorization packet'MySqlServer
- [network][easy case]troubleshoting the connection to a remote serverREMServer
- 程式(Processes)
- MySQL異常刨析:ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- 【故障處理】ORA-28547: connection to server failed, probableServerAI
- SESSIONS, PROCESSES, TRANSACTIONSSession
- Sessions & Processes parameterSession
- 轉載:有關SQL server connection KeepAlive 的FAQSQLServer
- Oracle RAC Background processesOracle
- 【轉載】Xlib: connection to ":0.0" refused by server的解決方法Server
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- Xlib: connection to ":0.0" refused by server Xlib: No protocol specified解決方案ServerProtocol
- 轉載:有關SQL server connection Keep Alive 的FAQ(2)SQLServer
- 轉載:有關SQL server connection Keep Alive 的FAQ(3)SQLServer
- mysql5.5_2013 Lost connection to Mysql server during queryMySqlServer
- How the JVM processes signalsJVM
- 增加連線數processes