RE: Slow Checkpointing....
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Jun 2010 15:29:07 -0400
>> I don’t *believe* adding writers should help unless the existing writers are already pegged. Since it completes when you checkpoint the hours versus minutes part does not add up. Thanks Mark. Oracle support hasn't provided any information on why we need to add more dbwr processes. System load is not high and certainly the dbwr processes aren't pegging CPUs. -Upendra From: mwf@xxxxxxxx To: nupendra@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Slow Checkpointing.... Date: Tue, 29 Jun 2010 14:59:44 -0400 Are the two writer processes you already have pegged on CPU? Has anyone monkeyed around with renice on other processes so the db writers only get time when you checkpoint? I don’t *believe* adding writers should help unless the existing writers are already pegged. Since it completes when you checkpoint the hours versus minutes part does not add up. good luck, mwf From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Upendra N Sent: Tuesday, June 29, 2010 2:48 PM To: oracle-l@xxxxxxxxxxxxx Subject: Slow Checkpointing.... I have a 188.8.131.52 EE database running on Solaris 10 using ZFS storage volumes. We have two ZFS pools - 1. control files and redo logs, 2. Data files. We have been seeing issues where the redo logs stay in "active" status for a long period (several hours - even when the system is idle). We are able to manually checkpoint without any errors, it completes <5 mins. Oracle support is suggesting to increase dbwr processes. We have 8 CPU (single core) sockets with db_writer_processes =2. Have anyone seen similar issues? What do you think? Thanks much -Upendra The New Busy is not the old busy. Search, chat and e-mail from your inbox. Get started. _________________________________________________________________ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2