Where all can the /*+ PARALLEL */ hint be used? 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&gt; create /*+ PARALLEL */ table t1
( id number,
name varchar2(40));

Table created.

SQL&gt;


Except INSERT and UPDATE, when all is the PARALLEL hint considered?
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.