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.
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:
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.
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 ...