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.

Improve this question
4
  • Do you have an error message you can share?
    – Anthony Genovese
    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.
    – Douwe van der Meer
    Sep 2, 2021 at 9:29
  • So what did you discover when you googled 'ORA-02391' ?
    – EdStevens
    Sep 2, 2021 at 13:26

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.