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 <nsouto_at_optusnet.com.au>
wrote:
> > Shrake, Jolene <JEShrake_at_Pella.com> 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
> nsouto_at_wizofoz2k.com.au
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Nuno Pinto do Souto
> INET: nsouto_at_optusnet.com.au
>
> 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: ListGuru_at_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).
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: mhthomas_at_yahoo.com
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: ListGuru_at_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).
Received on Wed Jan 07 2004 - 17:49:25 CST
