关于表和索引的并行度的设置

表和索引的degree一定要设置为1

select table_name,index_name, degree from dba_tables where OWNER='xxx' and DEGREE>1 ;

select table_name,index_name, degree from dba_indexes where OWNER='xxx' and DEGREE>1 ;

 

ALTER TABLE table_name NOPARALLEL;

ALTER INDEX index_name NOPARALLEL;