Parallel Operations Archives

Using Parallel Processing to Improve Oracle Database 12c Performance

Improving performance (and by this we usually mean query performance) is always a hot item with database administrators and users. One of the best and easiest ways to boost performance is to take advantage of the parallel processing option offered by Oracle Database 12c (Enterprise Edition only). Using normal (that is, serial) processing, the data involved […]

Optimizing Parallel Operations in Oracle RAC

Parallel operations that can be performed in any scale-up or single-system SMP image environment can also be performed in the scale-out Oracle RAC cluster environment. Learn more.

Oracle Performance Comparisons and Monitoring Parallel Operations

Reviewthe performance difference between a nonparallel operation and a parallel operation in Oracle in the example tests in this article.

Create Oracle Table and Index Examples with Parallel Operations

The implementations of parallel operations for table and index creation in Oracle illustrate the application of parallel operations in SQL statements. Learn more.

Manage Oracle Parallel Server Resources and Statement Queueing

In Oracle, you configure the allocation of parallel server resources for a consumer group with the PARALLEL_TARGET_PERCENTAGE directive. Learn more.

Basic Concepts of Parallel Operations in Oracle

Although there are some overhead costs and administrative requirements, using parallel operations in Oracle can improve the performance of many queries. Learn more.