My Oracle Support Banner

How to Determine Which Database Session ID is Associated With a JDBC Connection (Doc ID 1014494.102)

Last updated on APRIL 25, 2023

Applies to:

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


Goal

You are running a JDBC application or applet and would like to obtain the session id for the database session associated with your current JDBC connection.

This may be desirable in cases where you are debugging and need to be able to associate a particular client application with a specific database session.

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!

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