Unable to increase the number of dbwriters in 9i
585553Jun 28 2007 — edited Jul 16 2007Hi all,
I have a 9i instance (release 9.2.0.1.0) in which the number of db_writer_processes is less than configured in spfile.
The configured value is spfile is 4 but the number of background DBWriter
processes started is just 2.
I don't know why, since the related parameters are:
db_writer_processes=4
dbwr_io_slaves=0
cpu_count=4
dbblock_lru_latches=16
The 9i Administration Guide is not clear about the maximun number of dbwriters allowed.
Reples will be apreciated.
Alejandro Gustavo Restuccia