Here is the detailed process for How to get Trace FileWhen
you enable SQL trace in a session for the first time, the Oracle server
process handling that session will create a trace file in the directory
on the database server designated by the user_dump_dest initialization
parameter. As the server is called by the application to perform
database operations, the server process will append to the trace file.
Query:
------------
select name,value from V$PARAMETER where name = 'user_dump_dest';