|
|
| |
 |
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Parallelism And Oracle Data Warehousing
Tuning The Parallel Server
To fully appreciate the facilities of the Oracle parallel server, we
need to take a look at the two types of parallelism: internal and
external.
* Internal parallelism--Oracle takes an SQL query and fires
off concurrently executing processes to service the SQL request.
* External parallelism--The operating system parallels the
query.
Oracle recommends that data warehouse applications use parallel
server if the hardware is clustered or arranged in an MPP
environment. For SMP, parallel query may be used, but in SMP cases,
the data is usually loaded into Oracle at night, and the warehouse
is read-only during the daytime hours.
This is an excerpt from "High Performance
Data Warehousing".
 |
If you like Oracle
tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference
, with over 900 pages of BC's favorite tuning tips & scripts.
You
can buy it directly from the publisher and save 30%, and get instant
access to the code depot of Oracle tuning scripts. |
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
