Parallel select
select /*+ PARALLEL(t,4) */ count(*) from emp t; show parameter parallel; show parameter cpu; ALTER SYSTEM SET parallel_max_servers=8; alter session enable parallel dml; select /*+ PARALLEL(t,4) */ count(*) from emp t;