Degree of parallelism can be implemented at the instance level (in init.ora), table level or query level. You can use the command:alter table table_name degree=2 (don't quite remember the exact syntax, give it a try). Yes, it can be changed back.