Oracle CPU?DML/DDL??????
Oracle?????DML?Data Manipulation Language??DDL?Data Definition Language????CPU???
SQL?CPU???
1. CPU??????????????
2. 10GB?SQL???30????CPU?????alter session???????
1. ????table/index degree?????????
2. ??alter session enable parallel dml?????DML??????????????
1. ??append parallel(a,4)???????????
2. ????????parallel(b,8)?????????execute immediate???????
alter session enable parallel dml
RAC?cache fusion???
1. ?RAC?????parallel_instance_group?????
2. ???????dw?dw1?dw12?dw124???DML?????
1. ??DML?????
2. ??DML??????? 3. CPU???????PL/SQL????SQL??
1. ??v$pq_sesstat????????????
2. ??????DML????????????RAC????SQL????
1. ??parallel_max_serversx?256
2. ?systemuser????????4?10DML???????
1. ????DML??
2. ??DML??????? 3. CPU?????????parallel_index??
??parallel_index hint?????????
?????Oracle????????
