Optimal Oracle environment for small to medium capacity databases

Szymon (Senior Blackboard Solutions Engineer / Database Administrator) posted 1 minute ago | Comments (0) Oracle databases rely on their environment for processing capacity resources and business continuity options. Processing capacity is simplified to CPU, memory, and disk I/O resources. As hardware becomes less expensive and new architectures become available, the "sweet spot" for solutions comes and goes (figure 1). This position paper investigates Oracle RAC optimal circumstances versus single instance installations. RAC opportunity exists when a large number of small, inexpensive systems is clustered together to deliver hardware database resources. This applies especially to applications performing much of business processing at the database level or applications which grow faster than capacity of affordable hardware on... [read full story]