Re: OLTP 10x improvement with exadata and flash write back cache
- From: Kevin Closson <ora_kclosson@xxxxxxxxx>
- To: "hrishys@xxxxxxxxxxx" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2012 15:12:34 -0700 (PDT)
The photo shows "10x more write I/O's"
To drive DBWR at a rate of 10x you need CPU. That is, if free buffer waits are
holding your processor-utilization at about 10% and your app (and what your app
does to the Oracle database concurrency code) scales you might get 10x... but
then don't forget that your observed processor utilization on modern processors
(most of which have SMT) includes thread execution so a server that is at about
70% is generally maxed out.
In other words, it depends.
________________________________
From: hrishy <hrishys@xxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, October 24, 2012 11:19 PM
Subject: OLTP 10x improvement with exadata and flash write back cache
Hi
Has anybody started using this feature
https://twitter.com/fritshoogland/status/235146135084351488
of and experienced a 10X improvement in their OLTP applications by enabling
flash write back cache ?
Under what specific circumstances do you think that 10X improvement is
possible.
What bottleneck would motivate us to turn on the exadata flash write back cache
feature
Can a SSD also achieve the same thing as a flash write back cache ?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
