Question 1 of 39
A DBA is tasked with optimizing the performance of a busy e-commerce database. They observe high CPU utilization and frequent waits for the \'log file sync\' event. The database experiences a high volume of transactions, and users are complaining about slow commit times. The DBA suspects that the redo log buffer is not being flushed efficiently. Which parameter is most critical for tuning the redo log buffer flushing mechanism to reduce commit latency?
LOG_BUFFER
DB_CACHE_SIZE
SHARED_POOL_SIZE
PGA_AGGREGATE_TARGET

Preparing for Oracle Database Administration II (1Z0-083)? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free