Database Tuning (MOSC)

MOSC Banner

How To Decide Whether Or Not to Increase DB_WRITER_PROCESSES

I am working with a database where 3rd party DBAs are assisting. One of these DBAs wants to increase the DB_WRITER_PROCESSES from "1" to "2" (or even higher). I've tried to do research on the topic (being new to performance tuning) and have been advised to check on Free Buffer Waits and Write Complete Waits in an AWR report. If counts for these waits show high values then it might be ok to increase DB_WRITER_PROCESSES

So how would one determine whether Free Buffer Waits and/or Write Complete Waits were high?

Using Oracle 12.2 running on Windows Server 2019 host

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center