Oracle DB with SSD
I have a HP DL 380 G7 + 2 Xeon Processors + 12GB DDR + 6HDD 10k RAID5
I know that RAID 5 is not the best choise for a Oracle database with writing, but it's cheaper than RAID 10.
But the Database was smooth, no locks, relative fast, but there is a new legislation that forces anyone to have a certificated application. This certificated application records everything you do, every click, every document you create, modify or read. Has you can imagine this made the database writing 10 to 100, and know it's getting slower.
Instead of going for RAID 10, i was thinking about SSD Technology.
Would it work to put a HP SSD/HD on the server for caching? I could put Redo logs, Temp, control files, etc inside this drive, to avoid too much writing processes on the SAS Drives.
This drives are very very fast, but they have a low life expectancy, if i'm not mistaken it's about 3 to 5 years with lots of writing.
What is you opinion? Could it work? Should i forget this and go straight to RAID 10?
Regards.