I fold :) --- Whittle Jerome Contr NCI <[EMAIL PROTECTED]> wrote: > I'll see your 'analyzed every 4 hours' and raise you one. We have > some tables that are analyzed every time they are used! They are > 'work' tables that are sometimes empty, very full, or somewhere in > between. Running something when the statistics say the table is full > but actually is empty takes a little longer when CBO says use > indexes; however, if CBO thinks the table is empty and does a FTS > when there's actually a million records, well let's just say it takes > a while. Hints work sometimes; however, analyzing these table after > they are populated and letting CBO do it's job usually works best. > > Two points. > > First this particular database had not been analyzed for over a year > when I got there and this database gets larger daily. They added > indexes but it didn't make much difference. After analyzing, most > things were much faster; however, the 'work' tables started acting up > depending on their state when analyzed. We now analyze twice a month. > > Second when it comes to these 'work' tables, I wasn't there and it > wasn't my idea! > > Jerry Whittle > ASIFICS DBA > NCI Information Systems Inc. > [EMAIL PROTECTED] > 618-622-4145 > > > -----Original Message----- > > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED] > > > > I have you beat.... one schema in one of our databases (9.2.0.2) is > > analyzed every 4 hours. Not mine, and I *will* be talking to the > DBA > > about his reasoning... > > > > however Jonathan's point may well be the reason. This is an > > ever-growing database, frequent insert and updates, and sequences > are > > used throughout. > > Analyze is "estimate" at least. > > > > --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > > > Mogens, if you are looking for a poster boy ... > > > > > > We analyze 9 production databases ... *every day*. > > > Raj > > >
__________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
