after burning my fingers I went back to default values!! Thank you. But = trying to set optimal values with more info. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Sent: Monday, April 19, 2004 12:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: oica/oic 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------