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 tkprof utility to consolidate trace files, and the trcsess utility to interpret trace files
• B. by using the DBMS_TRACE package to enable tracing and 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 setting TRACE_ENABLED = TRUE and using the tkprof utility to consolidate and interpret trace files
• E. by using the DBMS_MONITOR package to enable tracing, the trcsess utility to consolidate trace files, and the tkprof utility to interpret trace files

Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)

• A. Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.
• B. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.
• C. Create services for the applications and set a relative priority by assigning them to application users.
• D. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.

You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

• A. DBWR is not writing the dirty buffers fast enough.
• B. Several full table scans are performed by transactions.
• C. Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.
• D. Blocks are aging out of the buffer cache frequently.
• E. The database buffer cache is inadequately sized.
• F. A large number of blocks are fetched from disks frequently.

Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)

• A. In DSS workloads where full table scans may run in parallel and bypass the buffer cache, decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of full table scans.
• B. Decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of index probes for DSS workloads.
• C. Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the costing of an index probe that is done in conjunction with a nested loop for OLTP workloads.
• D. Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost of full table scans and can result in the optimizer choosing a full table scan over an index scan for both OLTP and DSS workloads.
• E. A full table scan can become cheaper than index scans if the database instance has a high enough DB_FILE MULTIBLOCK_READ_COUNT for both OLTP and DSS workloads.

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

• A. the V$ACTIVE_SESSION_HISTORY view
• B. the SQL statements based on elapsed time from the AWR report
• C. the Time Model Statistics section of the AWR report
• D. the Latch Activity section
• E. the Segment Statistics section of the AWR report