Whilst not disagreeing with the practical outworkings of what you, and others, have been saying for a while now I think that I disagree with the statement that tuning, or indeed database management more generally is 'science'. I think that the correct term is 'engineering'. In case this is just a definition of terms disagreement, I'd better define them. By Science I mean the process of observation,theory and test, that produces new and better explanations of how X works. By Engineering I mean the process of applying solid principles to build a known system to meet specified requirements. The two are clearly linked, and there certainly is a requirement that the science is done before the engineering - otherwise we are little better than high-tech witch doctors, but they are different. It is important that neither is 'art' especially not in the sense of a 'black art'.
Thus investigating how the number of freelists affects contention would fall in to the science category, setting the number appropriately to tune a response time issue for an OLTP system would fall into the engineering category. Niall Litchfield Oracle DBA Audit Commission 0117 975 7805 -----Original Message----- Sent: 26 February 2003 05:58 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Facts can have different "truths" only when those facts are filtered through the lenses of contradictory value judgments. Politics is an *excellent* example: lots of people describe themselves as believing in "equality." However, one political sector believes that equality means "equality of opportunity." Another believes that equality means "equality of outcome." Which you believe defines how you perceive the "truth" about many political issues. People's basic value judgments are often a matter of *faith*, which makes them impervious to change through intellectual debate. However, our small technical community has the luxury of far fewer differences in value judgment about what constitutes quality in our work. It's pretty easy to distinguish excellence from garbage when the two are laid out side-by-side. There might be optimizations that are superior for DSS environments and different optimizations that are superior for TP environments, but for the most part, we're all basing our professional careers in the same basic value judgment: that superiority means providing the fastest, most reliable data with the least possible economic sacrifice. With the advent of quantum microbiology and the like, most informed people agree that 21st medicine is a science. However, medicine as practiced in the 17th century was definitely an art, not a science. The argument that "tuning" is an "art"--that it is subjective like a symphony or like cooking--is rapidly losing. The measuring tools that allow us to approach "tuning" as a completely scientific endeavor have been present in the Oracle kernel now for over a decade. And some of our community's members with so-called shallow-minded views are doing an excellent job of finally figuring out how to apply them. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -----Original Message----- Robert - IL Sent: Tuesday, February 25, 2003 10:19 PM To: Multiple recipients of list ORACLE-L comm Yes, but WHO's truth..... Truth is a three sided sword, your side, my side and .... The edge...... Truth is, unfortunately, subjective.... Point in case, politics. :-) 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: Tuesday, February 25, 2003 9:54 PM To: Multiple recipients of list ORACLE-L comm The only thing wrong with President Wilson's advice is that exceptional oratory skill can, in the short term, overcome some pretty horrendous content deficiencies. I do have faith enough in free people to believe that in the long term, the truth wins. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -----Original Message----- Sent: Tuesday, February 25, 2003 8:29 PM To: Multiple recipients of list ORACLE-L comm Been a while since I have been able to scan the list, but who could resist this one??? :-) Additional Do's: Do understand the nothing is unbreakable or bullet proof, assume the impossible isn't and have a plan for disaster management. Do appreciate that oracle support probably does deal with enough clueless people to expect you to be one of the same until you demonstrate otherwise. Do remember that somewhere there is life outside of RDBMS challenges, and it should be kept relative. Do take the time to share your experiences, it makes life much simpler for all of us. Do clearly define the objective, before you start detailing the solution. Additional Do Nots Don't get so focused on a prescribed solution that you don't realize when it becomes self-defeating to the driving cause. Don't forget that as good as you are at being a dba, you will make mistakes and mis-manage, and so will those who make a living managing you. Don't forget to prescribe the solution that user needs, not the one they necessarily demand. And to the credit of Woodrow Wilson - "The wisest thing to do with a fool is to encourage him to hire a hall and discourse to his fellow citizens. Nothing chills nonsense like exposure to air." -----Original Message----- - IL Sent: Monday, February 24, 2003 10:40 AM To: Multiple recipients of list ORACLE-L * SHOCK * You mean someone disagrees with *ME*???? Horrors.... the world is soon to come to an end!! :-)) 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: 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 > > >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). > ===== Have a nice day !! ------------------------------------------------------------ Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Yount 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: Cary Millsap 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap 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). ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
