My Oracle Support Banner

How To Turn On Server Side Tracing From A JDBC Program (Doc ID 434462.1)

Last updated on AUGUST 30, 2023

Applies to:

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


There are many notes on server-side tracing via setting events on a session or system level (see references below). What the sample code included in this note shows is how to turn on server-side tracing from a JDBC program. By doing this we can set tracing only for the portion of the Java code that is causing the problem.


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
 Turning on SQL Tracing from a JDBC program.
 Tracing Oracle Errors
 Sample Program
 How To Determine The SQL Trace File Name From JDBC

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