Oh, you mean the SPIN_COUNT parameter... :-) on 3/25/04 8:11 AM, Cary Millsap at cary.millsap@xxxxxxxxxx wrote: > I agree. Following the procedure listed below reminds me of how > difficult it would be to take the lug bolts off a car wheel with the > wheel spinning at 1000rpm. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > * Nullius in verba * > > Upcoming events: > - Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle, 5/7 Dallas > - SQL Optimization 101: 3/29 Dallas, 4/19 Denver, 5/3 Boston, 5/24 San > Diego > - Hotsos Symposium 2005: March 6-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still > Sent: Thursday, March 25, 2004 9:06 AM > To: Oracle-L Freelists > Subject: Re: how to set optimizer_index_cost_adj and cache parameters? > > IIRC, the best option is to leave them alone. > > Jared > > On Thu, 2004-03-25 at 05:23, Juan Cachito Reyes Pacheco wrote: >> Hi, >> >> After reading a lot about this, this is my conclusion, do you agree? >> >> the conclusion seems to be gather system statics from every distinct > process >> or group of process, and set manually this values in every one of > them. >> >> If this process is by time, for example night and day, you can use > alter >> system parameter, >> if this is only for ap articular process you will have to set alter > session. >> >> And set the value. >> This seems to be a hard work. >> >> regards, >> >> >> ---------------------------------------------------------------- >> 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 > ----------------------------------------------------------------- > > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------