CFP last date
22 July 2024
Reseach Article

Load Balance Monitoring in Oracle RAC

by Neha Chandrima, Sunil Phulre, Vineet Richhariya
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 100 - Number 1
Year of Publication: 2014
Authors: Neha Chandrima, Sunil Phulre, Vineet Richhariya

Neha Chandrima, Sunil Phulre, Vineet Richhariya . Load Balance Monitoring in Oracle RAC. International Journal of Computer Applications. 100, 1 ( August 2014), 46-49. DOI=10.5120/17493-8013

@article{ 10.5120/17493-8013,
author = { Neha Chandrima, Sunil Phulre, Vineet Richhariya },
title = { Load Balance Monitoring in Oracle RAC },
journal = { International Journal of Computer Applications },
issue_date = { August 2014 },
volume = { 100 },
number = { 1 },
month = { August },
year = { 2014 },
issn = { 0975-8887 },
pages = { 46-49 },
numpages = {9},
url = { },
doi = { 10.5120/17493-8013 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2024-02-06T22:28:50.553165+05:30
%A Neha Chandrima
%A Sunil Phulre
%A Vineet Richhariya
%T Load Balance Monitoring in Oracle RAC
%J International Journal of Computer Applications
%@ 0975-8887
%V 100
%N 1
%P 46-49
%D 2014
%I Foundation of Computer Science (FCS), NY, USA

Oracle RAC offers and provides very attractive and promising features for today's challenging market scenario, where safety and availability of database is the basic need and demand of clients who are working on mission critical databases. The two most alluring features which RAC provides are high availability and load balancing. Load balancing is performed by the load balancer which most of the time works as desired; but it is noticed that failure of load balancer could be a single point of failure for the entire RAC system. In the present research work our aim is to monitor the load balancing feature of Oracle RAC in order to keep a close watch on whether switchover between nodes is happening correctly and smoothly or not. The concept of relative entropy is taken as inspiration, which helps us compare the randomness of the nodes and also the entire RAC system. A script is designed to monitor the number of sessions in each node which should run at the expected peak hours. These peak hours are discovered by extensive monitoring of sessions in each node for 30 days continuously. A threshold limit for number of sessions in each respective node is to be defined in prior, which should be near about but less than maximum session limit defined for the load balancer. As soon as the number of sessions in a particular node reaches its threshold limit, an email is sent to the DBA team which in turn alerts the team to keep a close watch on the switchover. In the proposed scheme the motto is to provide the client with a better service with the help of proper monitoring. To insure an even workload distribution, a clustered database must employ methods to distribute incoming sessions evenly and effectively across the various components of its cluster. As soon as the DBA gets email showing the threshold limit is reached, the DBA must become alert. If he notices that switchover or in other words load balancing is not happening properly, he can do a manual switchover to prevent the client from suffering with rejection of server. In present work Relative Entropy calculation technique is used as an inspiration to calculate the randomness of the RAC system based on its load balancing feature. Proposed scheme can minimize the cost as we can tune up the memory or SGA/PGA based on our result reducing the time to fetch as well. The Relative Entropy calculation scheme of detecting the randomness of Oracle RAC system is a truly new approach based on which we can monitor as well as forecast the behavior of its load balancing act. Proposed method also could help to detect any upcoming issue related to load balancing which could interrupt the client services. The proposed mechanism has overcome some of the limitations like it can be automated without any prior installation.

  1. docs. oracle. com/cd/E11882_01/rac. 112/e41960/admcon. htm
  2. Gong Weihua and Wang Yuanzhen, Jan, 2006 "A new load balancing scheme on heterogeneous database cluster" Geo-spatial information science; 9(3):216-222. DOI:10. 1007/BF02826771
  3. Stephane Ganc, Arski and Hubert Naacke "Load Balancing of Autonomous Applications and Databases in a Cluster System" Distributed data and structure 4, 162-164 -169.
  4. Zin Chen, Gokul Soundrajan,Madlin Mihaailescu 2007, "Outlier Detection for Fine-grained Load Balancing in Database Clusters" Proceeding ICDEW 07, Proceedings of 2007 IEEE International Conference on Data Engineering workshop, IEEE Computer Society Washington, DC, USA, 404-413
  5. Don MacVittie "Load Balancing Oracle Database Traffic" F5 Networks, Inc. White paper, 8-10, 888-882-4447
  6. Gia- Khanh Nguyen and Tim Read, July 2011 "Running oracle® real application clusters on oracle solaris zone clusters" An Oracle White Paper
  7. Deepali Kadam, Nandan Bhalwarkar, Rahul Neware, Rajesh Sapkale, Raunika Lamge, June-2011, "Oracle Real Application Clusters" Int. J of Sc. & Engg Research , 2, (6), 01-05, ISSN 2229-5518
  8. Rene Kundersma, 2012, "11gR2 Oracle Real Application Clusters Grid Infrastructure N. F. " otn. oracle. com/rac
  9. Howard Karlof and Kenneth Shirley, 2013, "Maximum Entropy Summary Trees" Eurographics Conference on Visualization (EuroVis) Vol 32, No. 3
  10. Markus Michalewic, June 2013, "Oracle Database 12c Real Application Clusters (RAC)" An Oracle White Paper,15-17
Index Terms

Computer Science
Information Sciences


Oracle RAC Load Balancing DBA Relative Entropy Clustered database