Wednesday 1 October 2014

parallel syntax for altering your entire sql session

 

As If I’m not going to write a “on login” trigger that runs this…  Surely I’ll be 8 times faster than everyone else (as you know, or maybe you don’t – this does not work in all situations).

alter session force parallel DDL PARALLEL 8;
alter session force parallel DML PARALLEL 8;
alter session force parallel QUERY PARALLEL 8;

No comments: