connection management call elapsed time in AWR report

In AWR report, under time model statistics section, there are lot of statistics ordered based on time(seconds) in the descending order

In some scenarios, “connection management call elapsed time” is one of the statistic which can be seen on top of the section with significant consumption of total DB time

To briefly describe this section, application connects to the database, parses the SQL and disconnects without executing the SQL

Application needs to be investigated for connection pooling options to optimize the session connection

Scenario 1:

In this case, the number of child cursors will be quite high for SQL with zero executions

version count is very high and executions will be zero

parse CPU to parse elapsed % will also have a bad value

In addm section, similar recommendation can be seen

Finding 1: Session Connect and Disconnect
Impact is 180.7 active sessions, 94.4% of total activity.
---------------------------------------------------------
Session connect and disconnect calls were consuming significant database time.
 
   Recommendation 1: Application Analysis
   Estimated benefit is 180.7 active sessions, 94.4% of total activity.
   --------------------------------------------------------------------
   Action
      Investigate application logic for possible reduction of connect and 
      disconnect calls. For example, you might use a connection pool scheme in 
      the middle tier.

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 )

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