Hi all,
I would like to trace the performance of SQL commands executed by a web aplication on Oracle 11.1.0.6.0.
I would like to trace on the entire database or instance.
I activated the trace by running
EXECUTE DBMS_MONITOR.DATABASE_TRACE_ENABLE(waits => TRUE, binds => FALSE, instance_name => 'inst1');
and this executed fine.
However, traces for the entire database/instance cannot be consolidated by trcsess utility.
In my Oracle ...\trace directory I have more than 1000 *.trc files and many of them seem to update automatically every couple of minutes.
How do I know which trace file to examine with TKPROF or any other tool ?
How do I know which file was created by the DATABASE_TRACE_ENABLE procedure and holds the SQL trace I am interested in ?
I can see that some *.trc files contain *diag* and *dia0* strings in their file names, but of course I cannot just assume that these are the ones created by DATABASE_TRACE_ENABLE because I have nothing to prove that.
Many Thanks,
G.G.