Forgot to say, if you really don;t know what to do with it, you could
use it for the Smart Flash Cache.
https://oracle-base.com/articles/12c/database-smart-flash-cache-12cr1
Most people have reported less than stellar results with this
functionality, but it is the "zero thought" option. :)
Cheers
Tim...
On Wed, Dec 16, 2015 at 4:40 PM, Tim Hall <tim@xxxxxxxxxxxxxxx> wrote:
Hi.--
The experience of Exadata Smart Flash Logging may prove useful in
making a decision. This feature allows Exadata to make two writes, one
to flash and one to disk. Whichever completes first wins. If you read
some of the posts about this feature, you will see a number of people
saying that very few writes complete first on flash. In Jason Arneil's
post it was 2.7% of log writes went to flash. In all other cases, disk
beat flash. Results will vary depending on the type of workload.
What does this mean in general terms, especially for non-Exadata
people? Redo on flash is not guaranteed to improve performance. In
some workloads, it could actually reduce performance.
As Kellyn mentioned in the quoted text above, you may get better bang
for your buck putting other things on flash like data files. As
always, the answer is "it depends". :) You need to make a change, test
it, rinse and repeat. :)
Cheers
Tim...
