August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel Processing
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,
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.
Requirements for Oracle’s Parallel Features
In order to use Oracle’s parallel processing features for your database applications, you must:
Have both suitable hardware and operating system software that supports parallel processing
Configure Oracle Server appropriately
Modify your database applications to get the benefit of parallel processing
Table 1.1 briefly summarizes the requirements for using Oracle’s parallel execution features and for using Oracle Parallel Server.
Table 1-1. Requirements for Using Oracle’s Parallel Features
|
Type of Requirement |
Parallel Execution |
Oracle Parallel Server |
|---|---|---|
|
Hardware |
Multiple processors (SMP, MPP, or NUMA). |
Multiple nodes (cluster, MPP, or NUMA cluster) shared disk architecture. |
|
Operating system software |
Operating system must support multiple processors. |
Operating system must support resource management and communication across nodes. The operating system also must support a disk-sharing configuration such as the use of raw devices on Unix and NT platforms. |
|
Oracle DBMS |
Configure initialization parameters. If using Oracle7, install the Oracle Parallel Query Option. |
Purchase and install the Oracle Parallel Server Option. Configure initialization parameters. |
|
Application |
Minor changes to SQL statements. |
Application partitioning. |
The following sections discuss some of the Table 1.1 requirements in greater detail.
Parallel Execution Requirements
Requirements for implementing parallel execution in Oracle are relatively straightforward. You need ...
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.