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 2³¹

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams231.htm#REFRN10197

PROCESSES

Default value: 100

Range of values: 6 to operating system dependent

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams199.htm#REFRN10175

TRANSACTIONS 

Default value:1.1* SEESSIONS

Range of values: 4 to 2³²

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams259.htm

transactions=1.1*sessions(defalt)

sessions=1.5*processes+22(default)

2.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26764973/viewspace-750485/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26764973/viewspace-750485/