Natti, Murali
Unknown Affiliation

Published : 3 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 3 Documents
Search

Reducing Oracle RAC Wait Events by Using Instance-Specific Block Allocation for Production Applications Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 1 No. 01 (2023): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v1i01.447

Abstract

Oracle Real Application Clusters (RAC) is a robust and high-availability solution designed to enable multiple database instances to share the same physical database, offering benefits such as scalability and fault tolerance. However, while Oracle RAC can support critical production environments, it introduces significant complexities, particularly with regard to wait events. One of the primary performance bottlenecks in Oracle RAC is inter-instance communication, commonly referred to as cache fusion, where instances must exchange and synchronize shared data blocks across the cluster. This overhead becomes particularly problematic for production applications that access commonly used tables or objects, leading to increased wait times, slower response rates, and reduced throughput. This paper outlines a novel approach that aims to alleviate Oracle RAC wait events by binding specific application instances to individual Oracle RAC nodes. By allocating frequently accessed tables or objects to specific nodes, this method reduces contention, optimizes database access, and enhances overall application performance.
Building Trust and Transparency: Leveraging Quarterly Business Reviews to Drive 4-Nines Availability and Proactive Customer Support Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 2 No. 01 (2024): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v2i01.448

Abstract

In the digital age, customers have heightened expectations for both service availability and support, making it crucial for businesses to provide consistent uptime and quality service. Building long-term partnerships depends on fostering trust, transparency, and accountability with clients. Quarterly Business Reviews (QBRs) are one of the most effective strategies to meet these expectations. These structured meetings allow service providers to share performance insights, discuss improvements, and outline future initiatives, ensuring customers feel confident in the reliability of the service they receive. This approach helps reinforce relationships, demonstrating a business’s commitment to service excellence. This white paper explores how QBRs can be leveraged to achieve 4-nines availability (99.99%), proactive support, and enhanced customer satisfaction. By using QBRs, companies can deepen customer engagement, showcase accountability through Root Cause Analysis (RCA) of service incidents, and highlight ongoing service improvements. The paper details the key components of a successful QBR strategy, emphasizing the importance of high availability, proactive customer support, and continuous improvement in fostering stronger customer relationships and achieving mutual business success.
Identifying and Managing Noisy Neighbors in Multi-Tenant PostgreSQL Deployments (On-Premise) Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 2 No. 03 (2025): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v2i03.488

Abstract

In on-premise multi-tenant PostgreSQL deployments, multiple tenants share the same physical infrastructure to maximize resource utilization and reduce operational costs. However, this shared environment can give rise to significant resource contention, particularly when one tenant exhibits the “noisy neighbor” effect—where its workload consumes a disproportionate amount of CPU, memory, or disk I/O relative to others. This unbalanced resource consumption can lead to widespread performance degradation, manifesting as increased query latency, reduced throughput, and overall service instability. The present article investigates the challenges inherent in multi-tenant setups, focusing on the detection and management of noisy neighbors. It explores both native PostgreSQL monitoring techniques (such as system views and performance statistics) and external solutions including Linux control groups (cgroups) for isolating and limiting resource usage. Additionally, the article outlines best practices for proactive monitoring, query optimization, and resource allocation to ensure a balanced and efficient multi-tenant environment. By providing a comprehensive framework for understanding and mitigating the noisy neighbor phenomenon, this work aims to equip database administrators and system architects with effective strategies for maintaining robust performance, even under heavy and unevenly distributed workloads.