Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Well.....

...this morning my wife looked around and harrumphed, "It must have been a *MAN* who said this is more than 20 inches". :-) Can't imagine what she was referring to...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, February 23, 2003 5:53 PM

> 20 INCHES of snow.... WOW!! When I moved up to Chicago in January, I
> expected at least a little snow.... boy, weve gotten just little snippets
of
> snow and that's it.... disappointing. Now I know where it's all gone!
>
> 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!
>
>
> -----Original Message-----
> Sent: Sunday, February 23, 2003 6:04 PM
> To: Multiple recipients of list ORACLE-L
> comments
>
>
> Robert,
>
> Thanks for sharing this...
>
> Sorry to chime in late (we got over 20 inches in the mountains this
> weekend!), how about "Don't execute any day-to-day SQL manually more than
> once; plan for reuse by scripting it the first time"?
>
> And, with all due respect, how about changing "Do Monitor Your Database"
to
> "Do Monitor Your Database Using Automatically Scheduled Scripts"?
>
> Just my $0.02...
>
> Thanks again!
>
> -Tim
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, February 23, 2003 3:23 PM
>
>
> > Here is the list of top 10 do's and don't that I came up with.
> >
> > #1 - Do Maintain your Expertise
> > #2 - Do Use the DBMS_STATS Package to Collect Statistics
> > #3 - Do Use Bind Variables
> > #4 - Do Put your Production Database in ARCHIVELOG Mode
> > #5 - Do Use Locally Managed Tablespaces
> > #6 - Do Monitor Your Database
> > #7 - Do Practice Recoveries
> > #8 - Do Get Involved with User Groups and Other Resources
> > #9 - Do Establish Standards and Change Control Processes
> > #10 - Do Think Ahead
> >
> > Bonus! - Do tune to Reduce Logical IO's Not Physical IO's.
> > (With regards to Cary!)
> >
> > Oracle Database Top 10 Don'ts
> > #1 - Don't Waste Time Re-Organizing Your Databases
> > #2 - Don't Use .Log or Other Common Extensions For Your Database File
> Names
> > #3 - Don't Leave Your Database Open To Attack
> > #4 - Don't Decide Against Hot Backups
> > #5 - Don't Use ASSM
> > #6 - Don't Forget the 80/20 Rule
> > #7 - Don't Stack Views
> > #8 - Don't Be a Normalization Bigot
> > #9 - Don't Forget to Document Everything
> > #10 - Do Not Use Products You are Not Licensed For.
> >
> > Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
> >
> > Ok, anyone wanna comment?
> >
> >
> > 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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).