Message-Id: <10523.108376@fatcity.com> From: "Joseph S. Testa" Date: Fri, 09 Jun 2000 08:39:34 -0400 Subject: Re: Index Rebuilds most definitely, if i remember correctly, u can analyze a table and its doesnt do an exclulsive lock on it(maybe my brain is fuzzy too as i've been on xml stuff for days). we used almost exclusively cost based now. 8.0, wtahc out for 8.1.5 bug , divide by zero error if you analyze a table with no rows in it(estimate, compute works fine). we have some batch programs that run m-f in evening and we are 24x7, so we analyze tables based on what we think is the least impact(since it does take up cpu cycles). hth, joe cyril wrote: > Hello! > > I am 'really surprised' that the solution 'commonly' provided for 'such > problems' is analyze the table.. > > Do people really analyze tables? ( I mean do u get so much down time! if > not how do u manage it!) > Do people really run their applications in COST BASED mode... > cos our organisation has been using Oracle6 onwards and since then the > applications have been tuned > for rule based and recently we tried to move to COST BASED and since all > the programs gave a huge problem > we cried off... > > Has anyone gone from RULE BASED to COST BASED.. can u help! > > -- > Author: cyril > INET: cyril@stockholding.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).