Method and Model to Assess the Performance of Clustered Databases: The Oracle RAC Case
Oracle allows for locking at the row level and uses a multi-version read consistency model. To provide scalability, Oracle embeds lock data into the data blocks within the database. For added availability and performance, Oracle provides Real Application Cluster (RAC), which has a shared cache and can operate on a shared Storage Area Network (SAN). This paper presents a methodology and analytic model aimed at assessing the performance impact of using a RAC versus running the database on a single server. Experiments are used to demonstrate the use of the methodology and model.