http://blog.itpub.net/25542870/viewspace-2120924/
一、 Parallel query
默认情况下session 是ENABLE状态
1. 实现方式
1 Alter session force parallel query;
2 Alter table tab1 parallel n;
3 Hist方式
2. 并行度设置
Alter table tab1 parallel n;
Select /*+parallel(tab n)*/ from tab;
Alter session force parallel query parallel n;
如果没有设置将执行默认并行度
3. 默认并行度
单实例 = PARALLEL_THREADS_PER_CPU x CPU_COUNT
RAC = PARALLEL_THREADS_PER_CPU x CPU_COUNT x INSTANCE_COUNT
SQL> show parameter parallel
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_limit string CPU
parallel_degree_policy