专注于数据库技术研究和实践,目前就职于互联网金融企业,提供Oracle数据库技术支持和维护。 联系电话:18616803656
发布时间:2017-04-13 11:58:53
The parallel_clause lets you parallelize creation of the table and set the default degree of parallelism for queries and the DML INSERT, UPDATE, DELETE,and MERGE after table creation.
NOPARALLEL: Specify NOPARALLEL for serial execution. This is the default,即并行度为1.
PARALLEL: Specify PARALLEL if you want Oracle to select a degree of parallelism equal to the number of CPUs available on all participating instances times the value of the PARALLEL_THREADS_PER_CPU initialization parameter.......【阅读全文】