Re: OLTP 10x improvement with exadata and flash write back cache
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2012 17:15:11 -0700 (PDT)
Hrishy,
Assuming that all writes go to flash cache, most benefits could come from:
1) Out of row stored Lob (with no cache option) direct path writes.
2) Direct path writes generated by sort's spilling to temp files.
3) Direct path writes generated by Index build, bulk loads, CTAS, etc.
4) Faster checkpoints and this would help physical standby catch up faster (if
it was lagging) as log boundary checkpoints on the standby are done while media
recovery wait on it. Oracle introduced couple of new parameters to influence
log boundary checkpoint in 11.2.
Unless your buffer cache is not configured properly, foreground processes
waiting on DBWR for free buffer waits is typically not seen and hence it may
not be a big benefit.
Thanks,
Sai
http://sai-oracle.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
