Ewwww! That icky LMT option? Ick! Ick! Ick! Thx! Rich
Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Monday, February 24, 2003 10:29 AM To: Multiple recipients of list ORACLE-L comm "Automatic Segment Space Management" -----Original Message----- Sent: 24 February 2003 15:39 To: Multiple recipients of list ORACLE-L comm I'm curious as to an explanation on don't #1 (what constitutes "reorganization"?) and what is ASSM for don't #5? "Assembly"??? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Monday, February 24, 2003 7:09 AM To: Multiple recipients of list ORACLE-L comments MccDBA: It is just Robert's Don't list ;) but you can always give your opinion abt that. Would you mind telling us 'Why you don't agree on them?' KG --- dist cash <[EMAIL PROTECTED]> wrote: > > > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Mark Leith 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: Jesse, Rich 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).
