Oracle enable parallel DDL

If you have a very time consuming DDL, such as creation of an index on a very big table, I recommend to enable PARALLEL DDL. This enhances the performance by a big factor. Just put this command before the DDLs:

ALTER SESSION ENABLE PARALLEL DDL;

As a test I have created an index preceded by the above statement. Notice how the DDL is parallelized:

 1   ?     3520 ora8i    156 24   324M 52928K sleep    7:18 23.22 23.18 ora_p000_my_db
 1   ?     3522 ora8i    156 24   324M 52928K sleep    5:53 22.20 22.16 ora_p001_my_db
 1   ?     3529 ora8i    154 24   272M  1296K sleep    2:52  8.52  8.51 ora_p004_my_db
 0   ?     3524 ora8i    154 24   272M  1308K sleep    2:52  7.67  7.65 ora_p002_my_db

Wonderful!