How To Determine The Trace File Name From a JDBC Program (Doc ID 454951.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 9.2.0.8 to 10.2.0.3
Information in this document applies to any platform.

Goal

This article will show you how to determine the database trace file name when you have turned on sql tracing from the JDBC program. This will enable JDBC programs being run with sql tracing turned on to know exactly what the full path of the trace file name on the server is as it can be obtained with a simple query. 

Solution

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 hundreds of Community platforms