Which two statements are true about the trcsess utility?

Question

Options

• AIt merges multiple trace files and produces a formatted output file.
• BIt merges multiple trace files from a particular session into one single trace file.
• CIt produces multiple files only for DBA sessions, which can be consolidated into one formatted file
• DIt produces multiple files for a service, which can be consolidated into one formatted file using the
• EIt merges files pertaining to a user session scattered across different processes in a shared server

• A
  72% (39)
• C
  4% (2)
• D
  7% (4)
• E
  17% (9)

Explanation

The trcsess utility consolidates trace output from selected trace files based on several criteria: After trcsess merges the trace information into a single output file, the output file could be processed by TKPROF. * 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 * 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

No community discussion yet for this question.