Unfortunately, additional processing power alone will do little or nothing to improve Oracle performance. Over time, processor speeds have progressively increased at a geometric rate. At the same time; however, conventional storage access times have only improved marginally. This has resulted in a massive performance gap, felt most painfully by database servers, which typically carry out far more I/O transactions than other systems.
Super-fast processors and massive amounts of bandwidth are often wasted as storage devices take several milliseconds just to access the requested data. Implementing flash storage helps accelerate the most resource-intensive data that slows performance across the board.
This comprehensive white paper discusses methods for identifying I/O performance bottlenecks, and it points out components that are the best candidates for migration to a flash storage appliance. An in-depth explanation of flash technology and possible implementations are also included.