needed to trace a client session today as we have some transactions occuring from the application which intermittently fail for an unknown reason.
so I used these parameters
TRACE_LEVEL_CLIENT= 16
TRACE_DIRECTORY_CLIENT = c:\temp\
TRACE_FILE_CLIENT= client.trc
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON
however i became stumped – this was an Oracle 11g system and nothing was being created.
wasn’t until remembering this parameter that my local trace was being created:
DIAG_ADR_ENABLED=off
the reason? I forgot about ADR- Automatic Diagnostic Repository
ref : http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm