ded-mazay,

Solid State Drives (SSDs) and ASM (Doc ID 1476766.1)
Oracle Support For Solid State Drives (Doc ID 395728.1)

рекомендую к прочтению
https://flashdba.com/storage-for-dbas/

https://flashdba.com/2013/08/22/storage-myths-put-oracle-redo-on-ssd/
https://kevinclosson.net/2007/07/21/manly-men-only-use-solid-state-disk-for-redo-logging-lgwr-io-is-simple-but-not-lgwr-processing/

Довольно старая статья

https://blogs.oracle.com/mrbenchmark/entry/running_your_oracle_database_on

In a nutshell

My intent for this test was to show you (for a classic Oracle lightweight OLTP workload)

the good news :

→ When I/O bound, we can replace two Seagate 10k RPM HDDs with one INTEL/SUN SSD for a similar throughput and twice faster response times

→ On a one for one basis, the response time difference by itself (up to 67%) will make your end users love you instantly !

→ Peak throughput in memory compared to the SSD is very close : in peak, we observed 821 TPS (24ms RT) in memory and 685 TPS (30ms RT) on the SSD. Very nice !


and the bad news :

→ When the workload is CPU bound, the impact of replacing your HDD by a SSD is moderate while losing a lot of capacity.

→ The cost per gigabyte need to be carefully calculated to justify the investment.