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:
- In development and test, I agree there is no need for autoextend.
- 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).
Received on Sun Feb 23 2003 - 16:18:36 CST
