Oracle 限制每个用户的同时连接数
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17320402/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle limit on simultaneous connections per user
提问by Ersin Gülbahar
I want to connect Oracle DB with same user several time at the same time on java app. Is there any limitations? I want to connect db and read bulk data from same user.
我想在 java 应用程序上同时将 Oracle DB 与同一个用户连接几次。有什么限制吗？我想连接数据库并从同一用户读取批量数据。
回答by David Aldridge
In general there are not unless there is a limit specifically configured through the user profile, which can limit sessions_per_user.
通常没有，除非有通过用户配置文件专门配置的限制，可以限制 session_per_user。
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm
回答by Olaf H
The number of sessions is limited by the "sessions" configuration parameter of the database instance. According to the Oracle documentation the default value is (1.5 * PROCESSES) + 22.
会话数受数据库实例的“会话”配置参数限制。根据 Oracle 文档，默认值为 (1.5 * PROCESSES) + 22。
See also http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams232.htm#REFRN10197
另见 http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams232.htm#REFRN10197
Other related parameters are "processes" and "transactions".
其他相关参数是“流程”和“交易”。
In general it's not a problem to open several connection in an application to the same database user/schema at the same time. This is what application servers like JBoss are doing all the time.
一般来说，在一个应用程序中同时打开多个连接到同一个数据库用户/模式不是问题。这就是像 JBoss 这样的应用服务器一直在做的事情。
