Find trace file in oracle - oradebug

In order to make a more informative trace file name, the following command can be used:

alter session set tracefile_identifier = my_session;

A trace file will then have this identifier (here: my_session) in it's filename.

The trace file's name can also be found with oradebug:

SQL> oradebug setmypid
SQL> oradebug tracefile_name

Oradebug

The oradebug utility falls into the “hidden” classification of utilities due to the lack of available documentation. The utility is invoked directly from SQL*Plus beginning in version 8.1.5 and Server Manager in releases prior to that. The utility can trace a user session as well as perform many other, more global, database tracing functions.

oradebug requires the SYSDBA privilege to execute (connect internal on older Oracle versions). The list of oradebug options can be viewed by typing oradebug help at the SQL*Plus prompt: