How To Find The Database Session Associated with a JVM Thread (Doc ID 1485912.1)

Last updated on AUGUST 11, 2022

Applies to:

Goal

In the world of enterprise java applications, we are very often faced with the challenge of determining the
database session associated with a particular JVM thread. For example, we may need this information to understand
why a particular JVM thread is unable to complete a database transaction and leads to a JVM hang or deadlock. Unfortunately, there is no
direct way of finding this out from data dictionary views like V$Session because they do not hold the JVM thread
information. 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.