Parallel DDL

If an object, table or index, is created with PARALLEL, then Oracle will invoke parallel DDL, which is essentially parallel DML into sys objects, like obj$. It sounds to me that if you are creating an empty schema(no data at all), it’s better to just shutdown the parallel DDL altogether. The benefit of parallelism is very tiny when you have an empty schema(create index on a table of millions of rows is a whole different story) that it may not offset the overhead at all. Of course, when you are creating an empty schema, you probably will not worry about performance whatsoever.
To disable parallel DDL;
alter session disable parallel ddl;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: