End-To-End Metrics Support for Oracle / connection identification
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.