0

We are working on a fairly old batch application that has a few connections to an Oracle database, it uses mybatis or jooq, depending on how old the codebase is.

We gotten an alert yesterday regarding the number of connections that are occurring are about to exceed the max. And the cause is most likely from us.

Is there anyway I can find out how many connections are going to the Oracle Database from our application? We are using the Intellij Idea IDE Ultimate edition if that helps.

needoriginalname
  • 703
  • 3
  • 9
  • 27
  • Depending on the DataSource implementation, you might get access to the number of active Connection(s). But that also depends on how your application is run. Is it a single instance? Is it clustered/distributed? – LppEdd Feb 11 '19 at 20:39
  • 1
    *"the cause is most likely from us"* Try the duplicate link to show **all** connections on the database, then you'd know for *sure* who it is, instead of *guessing*. – Andreas Feb 11 '19 at 20:45

0 Answers0