0

As an analyst I'm running multiple queries on our Oracle ERP via Power Query (Power BI). Now, I hit some form of session limit on my default profile's session limit. How do you evaluate how many sessions I use without accessing the Oracle database directly? Are they the number of tables you access in the FROM statements?

Error message:

OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit.

4
  • Do you have an error message you can share? Sep 1, 2021 at 13:19
  • "Sessions" would generally correspond to the number of network connections to the database. It would not have anything to do with the number of tables being queried. The number of network connections you are attempting will depend on how Power BI works internally, and is limited by your Oracle user profile in the database.
    – pmdba
    Sep 1, 2021 at 14:18
  • Error message is this @AnthonyGenovese: OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit. Sep 2, 2021 at 9:29
  • So what did you discover when you googled 'ORA-02391' ?
    – EdStevens
    Sep 2, 2021 at 13:26

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.