Hi Raghu Kota I had investigated long time about the proper values for that parameters, and there are only two choices 1) leave them with default values 2) change them and set better values, but test the changes, you can use alter session to set more exact values to specific process. There is not a magic values that guarantee it will work ok with all your process. Here I have a paper about tuning, where I put two links about it http://www.geocities.com/juancarlosreyesp/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------