My Oracle Support Banner

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

Last updated on AUGUST 11, 2022

Applies to:

JDBC - Version 10.2.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

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