Method and Model to Assess the Performance of Clustered Databases: The Oracle RAC Case

Download Now
Provided by: George Mason University
Topic: Big Data
Format: PDF
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.
Download Now

Find By Topic