JDBC Backends

JDBC backend activity consists of all JDBC calls including inserts, queries, updates, getting connections from connection pools, and so on.

ClassMethod
oracle.jdbc.driver.PhysicalConnection
  • prepareStatement
  • prepareCall
  • commit
  • rollback
oracle.jdbc.driver.OracleStatement
  • executeQuery
  • executeUpdate
  • execute
oracle.jdbc.driver.OracleDataSource
  • getConnection
oracle.jdbc.driver.OraclePreparedStatement
  • executeQuery
  • addBatch
  • execute
  • executeUpdate
oracle.jdbc.driver.OraclePreparedStatementWrapper
  • execute
  • executeQuery
  • executeUpdate

The Java Agent measures the response time for a database call as the round trip time it takes for a JDBC call to return. The response time for a database call includes network round trip time + database connection time + SQL query time or any other time spent in the database.

By default, the agent identifies JDBC backends using the following logical properties of the database:

  • URL
  • Host name
  • Port number
  • Database schema
  • Version
  • Vendor

If a database backend has the same hostname, port number, and database type as a database server already configured in a database Collector, the database backend is automatically matched with the Collector, and drill-downs from the Application Flow Map, Tier Flow Map or Node Flow Map to Database Monitoring are enabled.

JDBC Backend Naming Properties

You can enable or disable the use of the following properties for JDBC backend identification:

Configurable Properties Default Automatic JDBC Backend Discovery/Naming Description

URL

Yes

JDBC URL provided to the driver

Host

Yes

Database host

Port

Yes

Database port

Database

Yes

Database schema

Version

Yes

Database version as reported by JDBC driver

Vendor

Yes

Database vendor as reported by JDBC driver