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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.