You observe that a database performance has degraded over a period of time. While
investigating the reason, you find that the size of the database buffer cache is not large enough
to cache all the needed data blocks. Which advisory component would you refer to, in order to
determine that required size of the database buffer cache?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM) Answer(s):
In your production database, the total waits and the time waited for log file parallel write are
significantly high. While investigating the reason, you find that there are three redo log groups
with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits?
A. start the log writer slave processes
B. increase the number of redoes log files
C. increase the size of the redo log buffer
D. place the redo log files on the different disks
E. increase the number of log writer processes