1Z0-117 · Question #26
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…
The correct answer is C. DBA_ENABLED_TRACES view. DBA_ENABLED_TRACES displays information about enabled SQL traces. 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…
Question
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?
Options
- ADBMS_SERVICE package
- BDBMS_MONITOR package
- CDBA_ENABLED_TRACES view
- DTrcsess and tkprof
How the community answered
(42 responses)- A5% (2)
- B2% (1)
- C81% (34)
- D12% (5)
Explanation
DBA_ENABLED_TRACES displays information about enabled SQL traces. 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.
Topics
Community Discussion
No community discussion yet for this question.