RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
Here' my fave... 1) DBA's are to create simple easy to follow with ample documentation.. with infrastructure work. In the long run it serves the company well as well as your fellow dba's trying to support your work at 3:00am. 2) The work should be developed with a corporate perspective as well as be a scalable solution. Brian -Original Message- Sent: Friday, February 28, 2003 7:19 AM To: Multiple recipients of list ORACLE-L comm I like this - it nearly fits in, give or take a little flexibility in interpretation, with my comments: Tuning (engineering) is what you do before the system goes live Trouble-shooting (science) is what you do after the system goes live Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: 28 February 2003 09:53 comm > 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'. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Spears, Brian 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).
Re: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
I like this - it nearly fits in, give or take a little flexibility in interpretation, with my comments: Tuning (engineering) is what you do before the system goes live Trouble-shooting (science) is what you do after the system goes live Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: 28 February 2003 09:53 comm > 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'. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
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, bef
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
I have to agree that it was the most entertaining Oracle presentation I have ever seen - and yet with lots of good stuff to take with you home from a guy who knows a lot about Oracle. Please re-consider your decision to move to Australia, Connor. Come back. Connor McDonald wrote: "Connor does a much better job of presenting than I do." Translation: Connor waves his arms about, swears more and uses a little more BS, gives beer to attendees --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote: > 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." Interesting quote. It's funny, I do present with some frequency, and I stress out about it every time I do I'm just sure that there are folks out there that know a lot more about the topic I'm talking about than I do. I fully expect, every single time, to hear hoards of folks laughing at me when I say something totally stupid. However, the best experience I have ever had presenting was at UKOUG this last year after my Oracle9i New Features presentation. First, I got some great feedback from Jonathan Lewis, which I was very thankful for (but, honestly, I was so out of it at the time (still in stress induced fight or flight mode) that I don't remember much of it!). Second, I saw a great presentation by Connor McDonald on 9i. Connor does a much better job of presenting than I do. Cheers to you all! 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 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 St
RE: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
> >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 > I would agree with you if what we had to tune were something immutable; I have always been more interested in moral philosophy than epistemology, but in my view one of the main features of 'science' is that it deals with the immutable laws of nature - as opposed to social sciences or economy, 'the dismal science', where the approach may be perfectly scientific but intuition and experience still have a huge part to play, not least because the ground keeps shifting and man is far from being the rational animal it is deemed to be. As long as what I have to tune is more often than not issued from the wobbly logic of developers trying to implement sometimes no less wobbly business rules, as long as I often have to resist the temptation of blowing everything up and rewriting everything from scratch, I personally feel more on the side of craftsmanship than science. 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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
"Connor does a much better job of presenting than I do." Translation: Connor waves his arms about, swears more and uses a little more BS, gives beer to attendees --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote: > >> 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." > > Interesting quote. It's funny, I do present with > some frequency, and I > stress out > about it every time I do I'm just sure that > there are folks out there > that know > a lot more about the topic I'm talking about than I > do. I fully expect, > every single > time, to hear hoards of folks laughing at me when I > say something totally > stupid. > > However, the best experience I have ever had > presenting was at UKOUG this > last year after my > Oracle9i New Features presentation. First, I got > some great feedback from > Jonathan Lewis, > which I was very thankful for (but, honestly, I was > so out of it at the time > (still in stress induced fight or flight mode) that > I don't remember much of > it!). Second, I saw a great presentation by Connor > McDonald on 9i. Connor > does a much better job of presenting than I do. > > > Cheers to you all! > > 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 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 Exte
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
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
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
This reminds me of the paper I wrote for American Goverment in high school. I don't recall the author, but the gist was that Free Speech must not be impeded, because in the end, the Truth will prevail. Very well said. Thank you Cary. Cary Millsap wrote: 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]> 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
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
Connor corollary to Wilson theory... "The truth will out...especially when demonstrated with free beer!" Freeman Robert - IL wrote: 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." Interesting quote. It's funny, I do present with some frequency, and I stress out about it every time I do I'm just sure that there are folks out there that know a lot more about the topic I'm talking about than I do. I fully expect, every single time, to hear hoards of folks laughing at me when I say something totally stupid. However, the best experience I have ever had presenting was at UKOUG this last year after my Oracle9i New Features presentation. First, I got some great feedback from Jonathan Lewis, which I was very thankful for (but, honestly, I was so out of it at the time (still in stress induced fight or flight mode) that I don't remember much of it!). Second, I saw a great presentation by Connor McDonald on 9i. Connor does a much better job of presenting than I do. Cheers to you all! 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 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]> 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
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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'.
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
>> 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." Interesting quote. It's funny, I do present with some frequency, and I stress out about it every time I do I'm just sure that there are folks out there that know a lot more about the topic I'm talking about than I do. I fully expect, every single time, to hear hoards of folks laughing at me when I say something totally stupid. However, the best experience I have ever had presenting was at UKOUG this last year after my Oracle9i New Features presentation. First, I got some great feedback from Jonathan Lewis, which I was very thankful for (but, honestly, I was so out of it at the time (still in stress induced fight or flight mode) that I don't remember much of it!). Second, I saw a great presentation by Connor McDonald on 9i. Connor does a much better job of presenting than I do. Cheers to you all! 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 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 - Th
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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 > >-
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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:
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
* 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, i
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
E! That icky LMT option? Ick! Ick! Ick! Thx! Rich Rich JesseSystem/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 JesseSystem/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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
A... but in my world view, DBA's need to THINK like developers, since we are always the ones who the real SQL tuning gets pushed down to. Also, DBA's often are called on to design the database, and when views are brought to them to create they need to ask themselves, is this really a good idea??? Same thing with respect to bind variables. We need to be saying, Uh, folks, don't you think this might be a good time to use bind variables? Of course, YMMV :-) 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 2:24 AM To: Multiple recipients of list ORACLE-L comments >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). -- 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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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 JesseSystem/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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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 JesseSystem/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).