oracle的table的parallel 参数对delete的影响

16:48:48 SQL> alter table testac011 parallel 1;
Table altered

16:49:29 SQL> delete testac011 where rownum<1000000;
999999 rows deleted

16:50:01 SQL> alter table testac011 parallel 10;
Table altered

16:50:19 SQL> delete testac011 where rownum<1000000;
999999 rows deleted

16:50:34 SQL> 

parallel 修改后，表的属性degree会发生变化

查询等dml会自动采用并发模式

select owner,degree,count(*) from all_tables where trim(degree)<>'1'  group by owner,degree