Using EBS 12.2 Data Source Connection Pool Diagnostics

Oracle E-Business Suite Release 12.2 employs JDBC data sources within Oracle WebLogic Server 10.3.6 to maintain a pool of connections for database connectivity. These JDBC data sources are associated with the managed servers (such as oacore and forms) in which Oracle E-Business Suite applications are deployed.

What is a connection leak?

Connections are checked out and then returned to the data source when the request is complete. A connection is said to be leaked if it is not returned, no longer associated with the connection pool, or otherwise recoverable.

How do you track them down?

We've published a new document that describes how to check for EBS 12.2 connection leaks:

• Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics (Note 1940996.1)

This document covers methods for monitoring connection leaks using the WebLogic Console, using Level 1 and Level 2 Diagnostics, and using GV$SESSION to track down connection pool issues.

Related Articles

• Oracle E-Business Suite 12.2.4 Now Available
• Creating a Maintenance Strategy for Oracle E-Business Suite