Announcement

Collapse
No announcement yet.

Connection Pool DEDICATED SECURITY Exhausted

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Connection Pool DEDICATED SECURITY Exhausted

    Hi everyone,

    In our production environment, we've got "CONNECTION POOL DEDICATED SECURITY EXHAUSTED" error and we had to bounce the application/web server.
    Our connection pool is already 20.
    1. May I know what could be the possible cause of this error ?
    2. Which log I must check and where to find them ?
    3. What is the purpose of connection pool ? What is good if we increase it ? Is there maximum limit with regard to server hardware resource ?
    Thank you.
    Sally.

    Reference = http://www.otmfaq.com/forums/f27/ded...exhausted-662/

  • #2
    Re: Connection Pool DEDICATED SECURITY Exhausted

    I've seen this happen on a few customer's instances. This occurs when for your instance, 20 pieces of integration, transactions hit the application server at the same exact time. It is tough to try to localize this, but you can try to review your apache access logs and try to figure out what caused this. You can also try to increase it to say 50, but you'll need to really get to the root cause because it could happen again.
    If my post was helpful please click on the Thanks! button

    MavenWire Hosting Admin
    15 years of OTM experience

    Comment


    • #3
      Re: Connection Pool DEDICATED SECURITY Exhausted

      Regarding your questions, please refer Metalink Note
      • 558031.1 - Questions on Connections Pools such as PRIMARY_THIN,DEDICATED_DBA used in OTM
      • 730041.1 - Connection Pool DEDICATED_SECURITY Is Exhausted
      • 465975.1 - Connection Pool DEDICATED_DBA is Exhausted
      • 735346.1 - Connection Pool PRIMARY_THIN Is Exhausted
      Just like Nick mentioned, there is no magic number for all connection pool.

      In one of my implementation, I had raised a Severity 1 SR for the similar issue. The way that Oracle Support suggested was to increase the number gradually and monitor via glog.webserver.datasource.CPDiagServlet
      --
      Joseph Liang
      MavenWire APAC
      http://www.mavenwire.com/

      Comment


      • #4
        Re: Connection Pool DEDICATED SECURITY Exhausted

        Hello,

        Please do below steps,

        1. Log in as DBA.ADMIN.
        2. System Administration -> Data Connection Management -> Data Source Manager.
        3. Enter: PRIMARY_THIN and edit this record - Go to the Pool tab.
        4. Change Maximum Capacity to <X> and save change.

        Thank you!


        Kr, Saad
        Let's connect on LinkedIn
        Mobile: +91 973 049 6886
        E-mail: [email protected]

        If my post was helpful, then click on the Like button

        Comment

        Working...
        X