Oracle Database 12c: Installation and Administration — Question 217

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (SRV1);
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

Answer options

• A. 1
• B. 2 and 4
• C. 2 and 5
• D. 3 and 4
• E. 3 and 5

Correct answer: B

Explanation

The command executed successfully enables tracing for the SRV1 service, which creates a trace file for each session (option 2). To aggregate these trace files, the trcess utility can be used (option 4). Therefore, the correct answer is B, as it includes the successful outcome and the method for aggregation. The other options either include incorrect outcomes or methods that do not match the requirements.