Parallel Processing
To assist with the processing of large amounts of data, Oracle provides parallel processing features that break tasks into smaller units of work capable of being executed concurrently. These features are of particular relevance to DSS environments. The following database activities can be parallelized:
Queries (select statements, including subqueries within delete, update, and insert statements, and create table as select). This feature is known as the Parallel Query Option (PQO).
Data Manipulation Language (DML) operations (as of Oracle8). Run the alter session parallel dml command to enable parallel DML.
Database load (SQL*Loader Direct Path).
create index and rebuild index operations.
Database recovery.
Index scans (as of ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
