Which two pieces of tuning-related information can you examine in the alert log to identify possible causes?

As a DBA, you notice that the response time of your database has degraded. Which two pieces of
tuning-related information can you examine in the alert log to identify possible causes? (Choose

two.)

As a DBA, you notice that the response time of your database has degraded. Which two pieces of
tuning-related information can you examine in the alert log to identify possible causes? (Choose

two.)

A.
frequency of log switches

B.
frequency of block corruption errors

C.
concurrent parsing and buffer cache latch contention

D.
the amount of CPU time spent on database user-level calls



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right. in alert log file
B is right. in alert log file
C.D. wrong