I don't say never use autoextend in production, I just say "think about
it" :)
- Freeman Robert - IL <FREEMANR_at_tusc.com> wrote:
> OK, I finished my top 10 do's and don'ts... I'll put my list in
> another post
> for anyone to comment on.
>
> THEN I looked at your list Rachel.
>
> I had some of yours on mine, but I actually disagreed with you about
> autoextend.
> I've had this argument with others before, and here is my POV:
>
> 1. In development and test, I agree there is no need for autoextend.
> 2. In a production environment, I say that all tablespaces are
> autoextend.
> All of them.
> I allow them to grow to a reasonable size, and monitor for them to
> extend. How do I
> monitor them? Glad you asked. I set the tablespace to extend such
> that
> there is never
> more than 1% free space available in the tablespace. I have my
> monitoring
> software
> keep an eye out for tablespaces at 19% empty, 10% empty and 5%
> empty. So,
> if I get
> an autoextend situation, I am notified by my monitoring software,
> but the
> application
> can continue.
>
> So, what if there is some run-away process? Well, thats where
> maxsize
> comes in. I
> will only let the datafiles grow so large. I usually give them
> enough
> room for what
> I would consider to be 3 months worth of normal growth.
>
> Of course, the very best thing to do is to allocate space *before*
> it's
> needed, but
> there are times when space estimations come up short, and rather
> than
> have a production
> problem I'd rather allow the datafiles to grow by some reasonable
> size.
>
> Of course, resumable space management in Oracle9i is a big helper
> here
> too!!!
>
> Robert
>
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (It's everywhere that I am!)
> Author of several books you can find on Amazon.com!
>
>
> -----Original Message-----
> Sent: Sunday, February 23, 2003 12:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> The article is available on the NYOUG website (www.nyoug.org) under
> the
> Technical Journal archives
>
>
> --- netmadcap_at_netzero.com wrote:
> > Rachel: where can we find that article ? can u post the url ?
> >
> > -----Original Message-----
> > Carmichael
> > Sent: Sunday, February 23, 2003 6:24 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > for the don'ts you could just read my paper "how not to be a DBA,
> the
> > top 20 mistakes" which I gave at IOUG last year
> >
> >
> > --- Freeman Robert - IL <FREEMANR_at_tusc.com> wrote:
> > > I'm collecting up a list of the top 10 do's and don'ts for DBA's
> > > for a little article I'm doing. Anyone want to provide their list
> > or
> > > part of
> > > it?
> > >
> > > RF
> > >
> > > Robert G. Freeman
> > > Technical Management Consultant
> > > TUSC - The Oracle Experts www.tusc.com
> > > 904.708.5076 Cell (It's everywhere that I am!)
> > > Author of several books you can find on Amazon.com!
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Freeman Robert - IL
> > > INET: FREEMANR_at_tusc.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).
> > >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, more
> > http://taxes.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_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).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <netmadcap_at_netzero.com
> > INET: netmadcap_at_netzero.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).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
> INET: FREEMANR_at_tusc.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).
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_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 Sun Feb 23 2003 - 18:35:29 CST
