August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel ProcessingBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.