End-To-End Metrics Support for Oracle / connection identification

Solution Verified - Updated -

Issue

We have multiple JBoss instances sharing one Oracle database and need a way to distinguish them on the Oracle side.

Oracle's End-To-End Metrics Support for JDBC applications allows to provide client_id, module and action metrics for database session and current operation so one could find and trace it easily in the V$SESSION table.

Oracle docs:

http://docs.oracle.com/cd/B19306_01/java.102/b14355/endtoend.htm
http://docs.oracle.com/cd/E11882_01/server.112/e16638/sqltrace.htm#PFGRF01005

How do we enable this inside JBoss ?

Environment

JBoss Enterprise Application Platform (EAP) 5.x
Oracle database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content