oracle ORA-02391: 超出同时 SESSIONS_PER_USER 限制
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8459593/
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
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
提问by bdev
I'm logging in remotely to my school's oracle server. Apparently I've exceeded the number of simultaneous connections and get the error ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
我正在远程登录我学校的 oracle 服务器。显然我已经超过了同时连接的数量并得到了错误ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I don't have admin privileges. Does anyone know how I can end my current sessions without admin privileges?
我没有管理员权限。有谁知道如何在没有管理员权限的情况下结束当前会话？
回答by Rob van Laarhoven
You don't tell us what sql client you are using.
您没有告诉我们您使用的是什么 sql 客户端。
You can only end sessions started from your machine by stopping the client processes. But this could result in idle sessions that are not disconnected by the server. This is a DBA responsibility.
您只能通过停止客户端进程来结束从您的机器启动的会话。但这可能会导致服务器未断开连接的空闲会话。这是 DBA 的职责。
If you are starting parrellel sessions (from jdbc connection pool for instance) you should limit the parrallel sessions.
如果您正在启动并行会话（例如从 jdbc 连接池），您应该限制并行会话。
But the problem could be your fellow students loggin in with the same user account as you. DBA should raise SESSION_PER_USER or create sepparate users for each student.
但问题可能是您的同学使用与您相同的用户帐户登录。DBA 应该提高 SESSION_PER_USER 或为每个学生创建单独的用户。
