Care to share why...? 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: Monday, February 24, 2003 6:29 AM To: Multiple recipients of list ORACLE-L comments I don't agree with "don't" #1 and #5. >From: "Stephane Faroult" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, >comments >Date: Mon, 24 Feb 2003 00:23:37 -0800 > > >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! > > > >Robert, > > DO #3 and DON'T #7 are developer stuff, not DBA stuff ... >I would gladly replace DO #3 by 'Relentlessly preach good practice to >developers'. I can hardly talk to a developer without mentioning >DBMA_APPLICATION_INFO in the first 30 seconds :-). > >Regards, > >Stephane Faroult >Oriole >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Stephane Faroult > 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). > _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).