http://www.pythian.com/news/28797/de-confusing-ssd-for-oracle-databases/
* Placing redo logs on SSD is not recommended. Exadata now has a “Smart Flash Logging” feature that uses redo logs on SSD. Note that it uses redo logs *also* on SSD. This feature allows Oracle to write redo in parallel to a file on SSD and a file on the magnetic disk, and finish the operation when one of the calls is successful. This is a no-lose situation that can only improve performance. This is not the case if you place your redo logs on both SSD and magnetic disks yourself, in which case the redo write will finish when the slowest device finishes writing, making it a no-win situation.
Testing the Datadog Explain Plan Visualizer with Oracle execution plans
-
Datadog recently released a free online service explain.datadoghq.com where
you can paste in your explained SQL execution plans with metrics as JSON
text a...
Acum 2 săptămâni
Niciun comentariu:
Trimiteți un comentariu