Home » Oracle » 1z0-117 » 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
Correct Answer: C
Explanation/Reference:
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: OracleDatabase Reference,DBA_ENABLED_TRACES
Download Printable PDF. VALID exam to help you PASS.
|
|