Forum Discussion
Resolver IOracle: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I reached out to my IT department and they doubled the total number of database connections. Thanks for the responses.
4 Replies
camargos88Community Champion
Check this link:
Solved: Power BI Desktop automatic refresh queries one-by-... - Microsoft Power BI Community
Maybe your user has a limit for sessions. So you can try disabling the parallel load and background refresh.
v-deddai1-msftCommunity Support
Hi ninos-shiba ,
The total number of database connections to the Oracle Database by the specified user has reached the maximum, and therefore no more connections can be established for the current user. Would you please refer the resolution in https://confluence.atlassian.com/jirakb/how-to-fix-ora-02391-exceeded-simultaneous-sessions_per_user-limit-errors-in-jira-800867831.html?
If this post help, please consider accept it as the solution to help others find it more quickly.
Best Regard,
Dedmon Dai
- ninos-shiba
I reached out to my IT department and they doubled the total number of database connections. Thanks for the responses.
You can increase simultaneous sessions in your oracle database. In the following link, you can find the right soloution:
https://docs.oracle.com/cd/B10501_01/server.920/a96525/e2100.htm
Just search for "Oracle: ORA-02391" on the webpage.
Good luck!
