problems with db_writer_processes parameter
Hallo,
my DB is running with two CPUs. For more efective writing data to RAID 5 discs I try to start 4 db_writer_processes. I can start 2 but not 4 of them. Is there any rule I do not now?
Please help me! Christian
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
Re: problems with db_writer_processes parameter
Quote:
Originally posted by ckiltz
Hallo,
my DB is running with two CPUs. For more efective writing data to RAID 5 discs I try to start 4 db_writer_processes.
raid 5 ?? immmm very bad for performance.
Last month only I say BYEBYE to Raid 5.
Now in 0,1.
Sleeping well in night.
consider changing 5.
Re: Re: problems with db_writer_processes parameter
Quote:
Originally posted by engiri
raid 5 ?? immmm very bad for performance.
Last month only I say BYEBYE to Raid 5.
Now in 0,1.
Sleeping well in night.
consider changing 5.
... It was not my decision to take RAID 5. I red in "Oracle9i Performance Tuning" RAID 5 is slow in writing but fast in reading in combination with Oracle.
Greetings from Christian