Announcement Announcement Module
Collapse
No announcement yet.
Kindlyseek for help that how to optimize configuration of DB connection at App layer? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Kindlyseek for help that how to optimize configuration of DB connection at App layer?

    Framework:
    Spring

    Data source
    com.jolbox.bonecp.BoneCPDataSource

    DB App info
    Oracle 11g
    64-bit redhat linux OS
    max Connections:4000 per 1 app, totally 2 apps.

    What's the issue?
    I met a issue that one DB connection with transaction is allocated for one thread to update DB sudden dead block other connections.

    What i did?
    1. Optimize the relevant logic related transaction.Commit transaction per one(to-N) data.
    2. Improve the maxConnectionsPerPartition and minConnectionsPerPartition, statementsCacheSize and partitionCount.

    What's my question?
    What's i did is enough to resolve this issue?
    How to optimize the relevant parameters of DB connections at APP layer?
Working...
X