Instead of seeking for the *best* setting, it will better to prove it. to simulate a typical loading in a testing env, try with different degree and pick up the one suited for you, that's according the loading, the capacity of your CPU and Memory. -- Regards Sidney Chen -- //www.freelists.org/webpage/oracle-l