Are there any general rules in terms of whether the caching, read-ahead, and write-back features should be enabled/disabled on a RAID controller to maximize Oracle performance?
Thanks,
Printable View
Are there any general rules in terms of whether the caching, read-ahead, and write-back features should be enabled/disabled on a RAID controller to maximize Oracle performance?
Thanks,
Always disable write-ahead cache for disks containining redo logs and archived logs.
The data that Oracle thinks has been written to disk might be still in cache and not written to disk. There is possibility of losing data from cache (power failure, battery problem etc.)
Sanjay
Thanks, SANJAY_G.
However, my controller's manual has two write policy options available:
Write-back caching: the controller sends a data transfer completion signal to the host when the controller cache has received all the data in a transmission.
Write-through caching: the controller sends a data transfer completion signal to the host when the disk subsystem has received all the data in a transmission.
I think your write-ahead cache is the same as the write-back caching on my controller. Am I correct?
Thanks,