Home » RDBMS Server » Server Administration » no. of buffers?
no. of buffers? [message #187625] Mon, 14 August 2006 13:55 Go to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Hey all,

What determines the number of buffers that DBWn should write to datafiles?

Thanks and Regards
Yasir Hashmi
Re: no. of buffers? [message #187629 is a reply to message #187625] Mon, 14 August 2006 14:07 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Eventually DBWn should write ALL modified blocks back to the data files. You don't want to lose any data, or do you?
Re: no. of buffers? [message #187632 is a reply to message #187625] Mon, 14 August 2006 14:13 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Thanks for replyng.
By default it writes all the dirty buffers to disks.
What if we want to set some limits?

Thanks and Regards
Yasir Hashmi
Re: no. of buffers? [message #187702 is a reply to message #187632] Tue, 15 August 2006 01:05 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Look at the following parameters: log_checkpoint_interval and log_checkpoint_timeout
Re: no. of buffers? [message #187786 is a reply to message #187625] Tue, 15 August 2006 11:09 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
But isn't the redo log files responsble for prevention of data loss.
LGWR writes before DBWn.

Thanks and Regards
Yasir Hashmi
Re: no. of buffers? [message #187801 is a reply to message #187786] Tue, 15 August 2006 13:19 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes it is. However, like I've said, eventually the data must be written to the data files as well.

Oracle writes to the redo log file before a COMMIT can return to the user. In contrast, the database writer is lazy - it updates the data files in the background during checkpoint operations.
Previous Topic: listener up and down
Next Topic: ORA-01034:ORACLE not available
Goto Forum:
  


Current Time: Thu Dec 08 16:20:21 CST 2016

Total time taken to generate the page: 0.18731 seconds