Re: Taking Advantage of Multiple CPUs

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/02/24
Message-ID: <6d01ls$7c2$1@news.ipass.net>#1/1

See below:

TimKArnold wrote in message
<19980225012700.UAA05684_at_ladder02.news.aol.com>...
>1. How does Oracle take advantage of multiple CPUs?
>

Yes.
>2. How can an administrator affect performance other
> than setting 'cpu_count' in INIT.ORA?
>

ALTER TABLE PARALLEL DEGREE n, where n equals the number of CPU's + 2 (rule of thumb, so to speak).

>3. How does a developer take advantage of multiple CPUs?
>

Parallel hint.
>TIA,
>Tim

In 7.3 (and 7.2, I believe), parallel full-table scans and parallel recovery are possible. In Oracle8, parallel full-table scans, index range scans, table and index parallel partition scans, etc. are possible.

Good luck,
Dave Received on Tue Feb 24 1998 - 00:00:00 CST