Your database has the ACCTG service configured for an accounting application that runs on a
middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled
tracing at the service level by executing the following command:
SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(‘ACCTG’);
Which statement is true?
A.
A single trace file would be created for all the sessions for the service.
B.
Three trace files would be created for the three modules in the application.
C.
The trace file would not be created because the module name is not specified.
D.
A trace file is created for each session that uses the service, regardless of the module and
action.
Reasonable answer.
In multi-tier environments where statements are passed to different sessions by the application server it can become difficult to trace an individual process from start to finish. To solve this problem Oracle have introduced End to End Application Tracing which allows a client process to be identified via the client identifier rather than the typical session id.
By tracing the service, all sessions using that service will be traced.
D