Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

It works with SELECT and UPDATE statements.

Are there some more statements with which it works?

I was able to use it with create, but am not sure if the hint was actually considered.

SQL> create /*+ PARALLEL */ table t1
( id number,
name varchar2(40));

Table created.


Except INSERT and UPDATE, when all is the PARALLEL hint considered?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

The Data Warehousing Guide has a chapter on parallel operations that goes over what operations can be parallelized.

You can't parallel-ize a simple CREATE TABLE statement (nor would you want to-- there wouldn't be enough work to be able to parcel it out to multiple worker threads). You can, however, parallel-ize a CREATE TABLE AS SELECT statement either by specifying the PARALLEL hint in the SELECT or by using the PARALLEL keyword in the CREATE.

share|improve this answer

Oracle supports parallel processing for a wide range of operations, including queries, DDL, and DML:

  1. Queries that involve table or index range scans
  2. Bulk insert, update, or delete operations
  3. Table and index creation
  4. The collection of object statistics using DBMS_STATS
  5. Backup and recovery operations using Recovery Manager (RMAN)
share|improve this answer
This doesn't answer the question. It's just a generic statement about Oracle's parallel capabilities, not a specific answer about where the parallel hint can be used. – Colin 't Hart Oct 28 at 12:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.