Shulou(Shulou.com)06/01 Report--

session:

Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.

12c (1.5 * PROCESSES) + 22

ALTER SYSTEM can be used in a PDB only to change the value of the SESSIONS parameter for that PDB. (Modify in PDB only)

For a CDB, the root container's SESSIONS parameter specifies the total number of sessions for the database.

the SESSIONS parameter does not count recursive sessions and hence does not require the 10% adjustment.

process ---The operating system process (not detailed here, exclusive and shared mode), while the session is the db layer, the two concepts are different.

Here are the attempts involved: (where concepts can be viewed in official files)

gv$session

gv$process

v$resource_limit

v$license

---Here is a shortcut reminder, modify this parameter most people will restart cdb, but in fact can modify the sessions in a node, and then shutdown immediate(of course, to quickly take effect can also be shutdown abort) One of the cdb nodes, and then startup, can also take effect, but remember to run this node service to start.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.