SESSIONS, PROCESSES, TRANSACTIONS
1. SESSIONS, PROCESSES, TRANSACTIONS
SESSIONS
Default value : (1.5 * PROCESSES) + 22 (ORACLE 11G) / (1.1 * PROCESSES) + 5 (ORACLE 10G)
Range of values: 1 to 231
PROCESSES
Default value: 100
Range of values: 6 to operating system dependent
TRANSACTIONS
Default value:1.1* SEESSIONS
Range of values: 4 to 232
transactions=1.1*sessions(defalt)
sessions=1.5*processes+22(default)
2.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-750485/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle sessions,processes 和 transactions 引數 關係 說明OracleSession
- Sessions & Processes parameterSession
- sessions,processes的監控方法Session
- sessions 與 processes 的計算關係Session
- DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS(asktom)Session
- Kill SessionsSession
- Transactions and beyond it..
- Ora-12516有可能是連線數過多,修改Oracle資料庫processes和sessionsOracle資料庫Session
- limit active sessionsMITSession
- db_writer_processes-log_archive_max_processesHive
- 程式(Processes)
- Commit Transactions (143)MIT
- Overview of Autonomous Transactions (150)View
- Shipping Transactions Date 相關
- Oracle RAC Background processesOracle
- 會話控制利器 gorilla/sessions會話GoSession
- Inhomogeneous deployment for replicated sessions is not allowed.Session
- How to get complete sessions informationSessionORM
- Kill all sessions of a specified user nameSession
- Connections and Sessions (110)Session
- How the JVM processes signalsJVM
- Dedicated and Shared Server ProcessesServer
- 增加連線數processes
- Connection/Session/Server ProcessesSessionServer
- The Oracle Background Processes for Sybase ProsOracleROS
- Types of Processes (108)
- Server Processes (112)Server
- Fragment Transactions和Activity狀態丟失Fragment
- MySQL 5.5 -- Metadata Locking Within TransactionsMySql
- New Background Processes In 10g
- Overview of User Processes (109)View
- Overview of Oracle Processes (111)ViewOracle
- Queue Monitor Processes (QMNn) (125)
- How To Automate Disconnection of Idle SessionsSession
- oracle profile sessions_per_user的用法OracleSession
- Oracle 19c Concepts(10):TransactionsOracle
- Laravel 之巢狀事務 transactions 實現Laravel巢狀
- Shared Server Processes (Snnn) (131)Server