Hi, Guys, in this case can we chill (in a friendly way) about the naive questions. At least her company has a job posting for Senior Oracle DBA. E.g.:
http://pella.kenexa.com/pellav4/newhr/jobdesc.asp?ID=1194 Maybe they really do need help? Sorry, their web site is really slow, too. ;-) HTH. Regards, Mike Thomas --- Nuno Pinto do Souto <[EMAIL PROTECTED]> wrote: > > Shrake, Jolene <[EMAIL PROTECTED]> wrote: > > > > I'm surprised at these responses. I'm asking what > sql statement most > > people use to identify tables that need > reorganization because of > > "holes". > > You don't have to be. There is plenty of material > available today online > that demonstrates the futility of "religious" > (meaning: dictated by dogma) > reorganizations. > > > We had an Oracle consultant here and he uses > > A con-sultant, perheaps? > > > What sql statement is used by others? > > None. There is no such thing as a statement that > will pinpoint > a need for a reorg. Unless you can prove to > yourself that reorganizing > any given table will improve anything in your > system, then just going > through the motions because there is a "hole" is > useless. > "Holes" are not necessarily the same as "disasters". > > If you are using a reasonably recent version of > Oracle (something you > should ALWAYS mention upfront is the version you are > running), > then you can get all the information you need from > the data in > the dictionary as well as the statistics info. > > And guess what: that is also all the information > Oracle itself needs and uses > to work around any potential problems "holes" might > have caused > in the past. > > Bottom line: only reorganize if you have a specific > reason, purpose and > target for doing so. Just doing it because a > con-sultant's SQL statement > says so, is turning yourself into a cookie-cutter > DBA. > Which may give your boss a very warm feeling about > your position, > but achieves preciously nothing in real terms. > > Cheers > Nuno Souto > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Nuno Pinto do Souto > 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). __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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).
