Exadata is targeted by Oracle at both data warehousing and OLTP. But what can you expect from Exadata in an OLTP environment? What are the strengths and weaknesses?
This session focusses on the different layers for data storage with Exadata, how to use them and what performance to expect.
The Oracle Exadata database machine is positioned as both a resolution for data warehousing and online transaction processing (OLTP). But does Oracle Exadata give you a 10x plus performance improvement in any case, and specifically with online transaction processing type queries? This session focuses on doing online transaction processing on Oracle Exadata with particular attention on doing logical IO using the Oracle buffer cache and on doing physical IO in which the function of the flash cache is shown. The last part covers writing on the Oracle database machine, which also is important for performing OLTP.
So, if you want to understand more of the performance implications of using Oracle Exadata for OLTP like databases, this is the session to go to.