O'Reilly logo

Oracle Parallel Processing by Sanjay Mishra, Tushar Mahapatra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Case Study 2: An OLTP Application on a Cluster

Bull-Bull, a stock brokerage company, maintains its trading application on an Oracle database. The database and the application are critical for the business of the firm. They need to be highly efficient and highly available, at least during business hours. The database has two types of users: direct and indirect. The direct users are the brokers; the indirect users access the database over the Internet. At peak hours of operation, the number of direct users goes up to 200, and the number of indirect users goes up to 800. The size of the database is 80 GB.

Application Requirements

The trading application is a mission-critical application for Bull-Bull firm. The success of the firm relies heavily on the performance and availability of this application. The application has the following performance and availability requirements:

High availability

The main reason for Bull-Bull firm’s existence is to buy and sell stock. Consequently, the availability of their trading application is of prime importance. The cost of unavailability is extremely high—on the order of millions of dollars per hour. Therefore, the hardware and the database application need to be configured in a way that eliminates single points of failure and that provides high availability.

Fast response to online users

Hundreds of online users use the application during trading hours, and hundreds of transactions are in process at any given time. The expected response time is on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required