Which two statements are true about the trcsess utility?
A.
It merges multiple trace files and produces a formatted output file.
B.
It merges multiple trace files from a particular session into one single trace file.
C.
It produces multiple files only for DBA sessions, which can be consolidated into one formatted
file using the tkprof utility.
D.
It produces multiple files for a service, which can be consolidated into one formatted file using
the tkprof utility.
E.
It merges files pertaining to a user session scattered across different processes in a shared
server configuration.
Explanation:
The trcsess utility consolidates trace output from selected trace files based on
several criteria:
Session ID
Client ID
Service name
Action name
Module name
After trcsess merges the trace information into a single output file, the output file could be
processed by TKPROF.
Note:
* trcsess is useful for consolidating the tracing of a particular session for performance or
debugging purposes. Tracing a specific session is usually not a problem in the dedicated server
model as a single dedicated process serves a session during its lifetime. You can see the trace
information for the session from the trace file belonging to the dedicated server serving it.
However, in a shared server configuration a user session is serviced by different processes from
time to time. The trace pertaining to the user session is scattered across different trace files
belonging to different processes. This makes it difficult to get a complete picture of the life cycle of
a session.
Reference: Oracle Database Performance Tuning Guide 11g , Using the trcsess Utility
* Now there is a new tool, a command line utility called trcsess to help read the trace files.
The trcsess command-line utility consolidates trace information from selected trace files, based on
specified criteria. The criteria include session id, client id, service name, action name and module
name.
B,E