Exit 1Z0-064 Oracle Database 12c: Performance Management and Tuning
Question 1 of 5
0% complete
Q1 Single choice

You are administrating a database that supports a mixed workload. Applications are running on a middle tier and use connection pooling to connect to the database instance. You want to trace all applications and modules that use the ORCL1 service to connect to the database instance.

How would you consolidate the SQL statements for sessions that are connected by using the ORCL1 service?

  • A

    by using the DBMS_MONITOR package to enable tracing, the trcsess utility to consolidate trace files, and the tkprof utility to interpret trace files

  • B

    by setting TRACE_ENABLED = TRUE and using the tkprof utility to consolidate and interpret trace files

  • C

    by setting SQL_TRACE = TRUE and using the tkprof utility to consolidate and interpret trace files

  • D

    by using the DBMS_MONITOR package to enable tracing, the tkprof utility to consolidate trace files,

    and the trcsess utility to interpret trace files

  • E

    by using the DBMS_TRACE package to enable tracing and the tkprof utility to consolidate and interpret trace files

Previous Next