Monday, January 23, 2023

Comparing Oracle Exadata Database Performance with Amazon RDS for Oracle

 Comparing Oracle Exadata Database Performance with Amazon RDS for Oracle


In this post, Case Study  Explaining how Tata Consultancy Services (TCS) supported a UK-based utility provider’s digitalization journey by comparing performance of their on-premises Oracle Exadata database with Amazon RDS for Oracle.

Use Case of a Utility Customer

A UK-based utility provider that was running its business on an old version of Oracle Utilities needed upgrading to meet future aspiration of growth and performance. The upgrade entailed moving to Oracle Utilities Customer to Meter (C2M), and the solution runs on the Oracle-native Exadata database.

While AWS was the preferred cloud platform for the customer, moving away from Oracle Exadata to Amazon RDS for Oracle was proving to be difficult due to concerns of degrading performance. In such scenarios, TCS proposes a time-bound Proof of Concept (PoC) to expedite decision-making.

The objective of the PoC was to prove the current workload can be supported on Amazon RDS for Oracle and give the customer confidence that the same level of database performance can be achieved by moving away from Oracle Exadata to Amazon RDS for Oracle.

Key principles for the PoC were:

  • Production workload should be carefully analyzed to identify simulation criteria.
  • Proper sizing analysis should be done to baseline the target environment.
  • Workload simulation needs to meet a high degree of precision.
  • Success criteria needs to be well-defined and measurable.
  • Results should be comparable in like-for-like setting.

In this scenario, only the database performance was compared between Oracle Exadata database and target Amazon RDS for Oracle and not the application layer.

Success Criteria

For this PoC, the following performance parameters were used to compare performance between Amazon RDS for Oracle with on-premises Oracle Exadata.

#ParametersTarget MeasureTools Used
1System performance of Amazon RDS for OracleAvg. CPU < 75%, avg. mem <75%, IOPS – Less than max assigned for the storageAmazon CloudWatch
2Replay reliability/divergence<5%, Number of rows returned by each call are compared and divergences percentage reportedRAT replay report
3Replay run time7 hrs. 16 minRAT replay report
4SQL efficiency – % DB changeSame as on premises or improvedRAT replay report and AWR report
5SQL efficiency – common/long runningSame as on premises or improvedRAT replay report and AWR report
6DB instance efficiencySame as on premises or improvedPerformance insights


Click on AWS Link below -

Oracle Exadata Database Performance with Amazon RDS


No comments: