Tag Archives: Performance issue

Connection management call elapsed wait in Oracle

Connection management call elapsed wait in Oracle

Error
One of the DB server is facing performance issue, on checking the statspack report, it show the connection management call elapsed wait event.
Connection management wait is due to high connect/disconnect of application session with the database.

Statistic                                       Time (s) % DB time
----------------------------------- -------------------- ---------
connection management call elapsed              13,768.3      86.5
DB CPU                                          10,748.8      67.5
parse time elapsed                               1,240.3       7.8
hard parse elapsed time                          1,182.8       7.4
sql execute elapsed time                           560.1       3.5

Cause:
High connects and disconnects session from the application. It may cause performance issues with connection management time elapsed wait.

Solutions:
1. Discussed with application team for recheck the connection setting, may they used connection caching for application.

2. You can enable connection pool feature introduced in 11g : Database Resident Connection Pooling (DRCP),
but with these you need to change the connection setting with POOLED keyword.
For configured and enabled please go to the link Database Resident Connection Pooling