What would you use to view the tracing information?

A database instance is configured in the shared server mode and it supports multiple applications
running on a middle tier. These applications connect to the database by using different services
and tracing is enabled for the services. You want to view the detailed tracing setting for particular
service.
What would you use to view the tracing information?

A.
DBMS_SERVICE package

B.
DBMS_MONITOR package

C.
DBA_ENABLED_TRACES view

D.
Trcsess and tkprof

Explanation:
DBA_ENABLED_TRACES displays information about enabled SQL traces.
Incorrect:
A: The DBMS_SERVICE package lets you create, delete, activate, and deactivate services for a
single instance.
B: The DBMS_MONITOR package let you use PL/SQL for controlling additional tracing and
statistics gathering.
Reference: Oracle Database Reference, DBA_ENABLED_TRACES