Home » Oracle » 1z0-117 » Which two statements are true about the trcsess utility?
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.
Correct Answer: AB
Explanation/Reference:
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 Guide11g,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.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
