Question: I want to know the commands that
I can use to manipulate my trace files for my session and process.
What are the commands to alter trace file attributes?
Answer: There are several ways to
manipulate the trace files for a current session, process
Finding Oracle Trace File for current session :
name = 'Default Trace
Finding Oracle Trace File for
all Current Database Process is in the the v$process view:
To find all trace files for the current instance you
query the v$diag_info view:
name = 'Diag Trace';