RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
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
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
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: 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: 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 Grou
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
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
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 - 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
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'. 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
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: 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: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm
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
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 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
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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).
RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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).
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
You brought to mind another one... DON'T assume that changes in one environment will have the same impact across all environments so DO test the impact of any change in all environments that you can, before implementing it in production. We had a change go in to the dev environment that fixed the performance problem there. Unfortunately, it made performance fall through the floor in test, which was closer to the production environment in data volume. Fortunately it was caught before it went into production. --- Cary Millsap [EMAIL PROTECTED] wrote: You guys are very kind, thank you. My LIO vs PIO thesis is this: 1. Too many PIOs *is* a bad thing. 2. But eliminating unnecessary PIOs isn't enough. Even completely memory-resident databases can perform horribly (not scale, consume dozens of hours per query, etc.) 3. If you begin by eliminating unnecessary LIOs first, then you often eliminate all the PIOs you needed to eliminate, by side-effect. About the Top-10 list, I'll add... DON'T do something to make the system faster until you understand the impact that your proposed activity will have upon the response time of your important user actions. (Some proposed activities create negligible impact, and some even create negative impact. When you try those activities that don't create sufficient *positive* impact, then you *waste* your company's resources.) DO learn how to figure out--quickly, accurately, and inexpensively--the impact of a proposed activity upon end-user response time. 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- Landrum Sent: Sunday, February 23, 2003 5:49 PM To: Multiple recipients of list ORACLE-L Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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, 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).
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
#4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Thomas Day 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).
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
I agree with not relying on a GUI tool, but can't necessarily agree with a Good DBA will use command line SQL first. Personally, I figure a good DBA should make effective use of their time. Use or don't use the tool when it makes sense to do so. I use the tools for one off items but not for applying mass changes or items I want to batch. Good thing I am not sensitive. :-) Perhaps a Don't Don't rush in applying changes to the database without reviewing/testing first. David Davis Mediocre DBA Manulife Financial From: Karniotis, Stephen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Date: Sun, 23 Feb 2003 16:28:43 -0800 This thread is great. Wish I was paying more attention to it. Here is one Don't Done rely on gui tools to accomplish any task. Great DBAs can endure the SQL to get the answer done. Good DBAs may opt for a GUI tool but will still use command line SQL first. Poor DBAs run for their GUI tools. Here is a DO Do always challenge yourself to find the solution. Do remember that other's have been through the same situation are available to help you. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Sunday, February 23, 2003 6:49 PM To: Multiple recipients of list ORACLE-L Subject:RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Darrell Landrum 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can withstand on that DB? If your recovery time for most situations is much shorter using ARCHIVELOG mode (perhaps on very large DBs or systems w/limited IO), wouldn't that be better than NOARCHIVELOG? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 9:04 AM To: Multiple recipients of list ORACLE-L comments #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Tom, Having a data warehouse database in NOARCHIVELOG is, like any other database, only the very last resort when ARCHIVELOG is simply not possible. Your advice results from several assumptions which may or may not be valid: * data warehouse are read-only; don't worry about transaction processing * data warehouses have lower availability expectations; the business wll not halt if it is down * data warehouses are not mission-critical; the business will not halt if it is down * we believe in rebuild-and-reload for DW, not restore-and-recover, so we use NOARCHIVELOG mode Ironically, data warehouses frequently spend enormous amounts of time performing extraction, transformation, and load (ETL), so they are anything but read-only. Depending on the complexity and duration of ETL processing, uptime and availability may be real concerns. I converted a Teradata DW to Oracle in the early 90s. This DW was loaded monthly, but Teradata could not process 4 weeks of data faster than 6 weeks, so months were being skipped. This was due to frequent outages as well as poorly designed ETL processes. The ETL process averaged 3-4 weeks, but outages would extend this to 5-6 weeks... The idea that the business will not halt if the DW is down is a view commonly held by organizations lacking a successful DW. Successful DW deployments frequently have ties from customer service into DW-supported systems, not to mention the irritation from on-high that accompanies a DW outage. Also, many DW systems have queries that legimately take days to complete, so daily or weekly outages are not an option. I have worked several DW systems where NOARCHIVELOG mode and the resultant rebuild-then-reload recovery mechanism has been in place, instead of ARCHIVELOG mode and the resultant restore-and-recover recovery strategy. Each time, our eyes were wide open to the advantages and benefits as well as the disadvantages and risks. The disadvantages and risks outweigh the advantages and benefits in almost every situation. One time, the DW simply didn't have access to suffiicient tape capacity for archivelog backups (we had planned to steal bandwidth on the mainframe tape drives, but they shut that down right quick!), which is a problem that was corrected when project funding permitted 3 years later. Another time, the activity on the DW database would have generated an *average* of 2 Tbytes of archived redo log files every day, sometimes peaking at 3-4 Tbytes. This time, considerable tape capacity was available, but it was still far from sufficient. Despite the mission-critical nature of this DW, it remains in NOARCHIVELOG mode to this day, despite several week-long outages during rebuild-then-reload recovery operations... NOARCHIVELOG mode should always be either an indication that the database is utterly unimportant or it should be the absolute last resort, the ultimate expediency, a stopgap until correction. It is never a viable option from a design or planning standpoint. Robert's do #4 is correct. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 8:03 AM #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L 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
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
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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
All the hearsay evidence I've seen (including comments attributed to Cary at his HotSOS symposium that I heard second hand last week) leads me to believe that don't #5 is true...I must admit I've not done benchmarking myself... :-) I am, however, ever open minded. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 6:39 PM To: Multiple recipients of list ORACLE-L comments why #5 on the don'ts? I know we've had lots of discussions on this list about it, but I haven't seen anything that made me think never ever use that --- Freeman Robert - IL [EMAIL PROTECTED] wrote: Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Rich, I agree. We have a warehouse here that is not in archivelog mode. They perform loads two days a week (Sunday and Monday) followed by a cold backup on Tuesday. The cold backup is now taking 18 hours to complete. I've suggested switching into Archivelog mode and performing Rman backups - at least the database is up and available to the users during the backup! It's probably going to happen, just waiting for the proper discussion. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, February 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L comments Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can withstand on that DB? If your recovery time for most situations is much shorter using ARCHIVELOG mode (perhaps on very large DBs or systems w/limited IO), wouldn't that be better than NOARCHIVELOG? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 9:04 AM To: Multiple recipients of list ORACLE-L comments #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Mercadante, Thomas F 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
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
* 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Title: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Another Do's ... 0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Oo, that *IS* a good one May need to add that to the list somewhere somehow. 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:04 AM To: Multiple recipients of list ORACLE-L You brought to mind another one... DON'T assume that changes in one environment will have the same impact across all environments so DO test the impact of any change in all environments that you can, before implementing it in production. We had a change go in to the dev environment that fixed the performance problem there. Unfortunately, it made performance fall through the floor in test, which was closer to the production environment in data volume. Fortunately it was caught before it went into production. --- Cary Millsap [EMAIL PROTECTED] wrote: You guys are very kind, thank you. My LIO vs PIO thesis is this: 1. Too many PIOs *is* a bad thing. 2. But eliminating unnecessary PIOs isn't enough. Even completely memory-resident databases can perform horribly (not scale, consume dozens of hours per query, etc.) 3. If you begin by eliminating unnecessary LIOs first, then you often eliminate all the PIOs you needed to eliminate, by side-effect. About the Top-10 list, I'll add... DON'T do something to make the system faster until you understand the impact that your proposed activity will have upon the response time of your important user actions. (Some proposed activities create negligible impact, and some even create negative impact. When you try those activities that don't create sufficient *positive* impact, then you *waste* your company's resources.) DO learn how to figure out--quickly, accurately, and inexpensively--the impact of a proposed activity upon end-user response time. 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- Landrum Sent: Sunday, February 23, 2003 5:49 PM To: Multiple recipients of list ORACLE-L Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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, comments
Good one for the don't list. I suppose that the ARCHIVELOG mode question depends on the situation, but for the most part I think ARCHIVELOG mode in production is a good do... Granted, if you don't have changes, then as long as you can stand the outage, then you can do cold backups. :-) 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 9:04 AM To: Multiple recipients of list ORACLE-L comments #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Thomas Day 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
On a DSS the database is usually in maintenance mode for batch updates (usually Friday night). After the updates you can do a cold backup or full export before bringing the database on-line for regular users. The database would normally not have any other update activity. But in most instances ARCHIVELOG mode would be the way to go. I do not really disagree with the list as it stands, I was just pointing out a reasonable exception. Jesse, Rich Rich.Jesse To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @qtiworld.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/24/2003 11:14 AM Please respond to ORACLE-L Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can withstand on that DB? If your recovery time for most situations is much shorter using ARCHIVELOG mode (perhaps on very large DBs or systems w/limited IO), wouldn't that be better than NOARCHIVELOG? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 9:04 AM To: Multiple recipients of list ORACLE-L comments #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
it's just that I've heard comments both pro and con on this list over the last week or so. Some thought it was great, others think it's not. Of course, I hate hard and fast rules anyway because in just about every situation the key words are it depends --- Freeman Robert - IL [EMAIL PROTECTED] wrote: All the hearsay evidence I've seen (including comments attributed to Cary at his HotSOS symposium that I heard second hand last week) leads me to believe that don't #5 is true...I must admit I've not done benchmarking myself... :-) I am, however, ever open minded. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 6:39 PM To: Multiple recipients of list ORACLE-L comments why #5 on the don'ts? I know we've had lots of discussions on this list about it, but I haven't seen anything that made me think never ever use that --- Freeman Robert - IL [EMAIL PROTECTED] wrote: Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
#11: DON'T attempt to use OID 9.0.1 on Linux with Replication because it DON'T work reliably! #12: DON'T use CURSOR_SHARING=FORCE in versions below 8.1.7.4 without expecting problems. #13: DON'T work against your Duhvelopers and SysAdmin Nazis. You're all working to the same goal (or should be). #14: DON'T expect MetaLink to have all the answers. #15: DON'T allow any third party vendor that uses an Oracle DB to setup the database. It will perform poorly, be all but completely unrecoverable, and will not adhere to any of the standards you've put into place for your company's protection and benefit. #16: DON'T accept a vendor's requirement for unsupported versions of Oracle. #17: DON'T be unyielding to compromise if it benefits your company (see #13). #18: DON'T take your love to town. (Oh Ruby) Perhaps not generic enough, but very important for our installation, IMHO. My $.02, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Another Do's ... 0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom. Raj -- 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
There are various problems with ASSM that result in lost space - e.g. rollbacks do not reset the btmaps correctly. I also have an example (see the website below for miscellaneous - bust bits) which demonstrates that the implementation of ASSM has not been rolled out across all space management code points. Also, you get a couple of space management blocks per extent, rather than a few per segment. On the other hand, my example is a special case, and if you don't care about leaking space all over the place, and if you have a problem relating to freelist (group) management in RAC, then ASSM may be a boon that you can afford to pay for. It's the usual cost/benefit/risk triangle. 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: 24 February 2003 16:29 comments All the hearsay evidence I've seen (including comments attributed to Cary at his HotSOS symposium that I heard second hand last week) leads me to believe that don't #5 is true...I must admit I've not done benchmarking myself... :-) I am, however, ever open minded. RF -- 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
I've had one too many experiences with but the environment is EXACTLY the same only to find out that it isn't. --- Freeman Robert - IL [EMAIL PROTECTED] wrote: Oo, that *IS* a good one May need to add that to the list somewhere somehow. 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:04 AM To: Multiple recipients of list ORACLE-L You brought to mind another one... DON'T assume that changes in one environment will have the same impact across all environments so DO test the impact of any change in all environments that you can, before implementing it in production. We had a change go in to the dev environment that fixed the performance problem there. Unfortunately, it made performance fall through the floor in test, which was closer to the production environment in data volume. Fortunately it was caught before it went into production. --- Cary Millsap [EMAIL PROTECTED] wrote: You guys are very kind, thank you. My LIO vs PIO thesis is this: 1. Too many PIOs *is* a bad thing. 2. But eliminating unnecessary PIOs isn't enough. Even completely memory-resident databases can perform horribly (not scale, consume dozens of hours per query, etc.) 3. If you begin by eliminating unnecessary LIOs first, then you often eliminate all the PIOs you needed to eliminate, by side-effect. About the Top-10 list, I'll add... DON'T do something to make the system faster until you understand the impact that your proposed activity will have upon the response time of your important user actions. (Some proposed activities create negligible impact, and some even create negative impact. When you try those activities that don't create sufficient *positive* impact, then you *waste* your company's resources.) DO learn how to figure out--quickly, accurately, and inexpensively--the impact of a proposed activity upon end-user response time. 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- Landrum Sent: Sunday, February 23, 2003 5:49 PM To: Multiple recipients of list ORACLE-L Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
thanks for the (Oh Ruby) reference. now it's stuck in my mind. -Original Message- Sent: Monday, February 24, 2003 2:20 PM To: Multiple recipients of list ORACLE-L #11: DON'T attempt to use OID 9.0.1 on Linux with Replication because it DON'T work reliably! #12: DON'T use CURSOR_SHARING=FORCE in versions below 8.1.7.4 without expecting problems. #13: DON'T work against your Duhvelopers and SysAdmin Nazis. You're all working to the same goal (or should be). #14: DON'T expect MetaLink to have all the answers. #15: DON'T allow any third party vendor that uses an Oracle DB to setup the database. It will perform poorly, be all but completely unrecoverable, and will not adhere to any of the standards you've put into place for your company's protection and benefit. #16: DON'T accept a vendor's requirement for unsupported versions of Oracle. #17: DON'T be unyielding to compromise if it benefits your company (see #13). #18: DON'T take your love to town. (Oh Ruby) Perhaps not generic enough, but very important for our installation, IMHO. My $.02, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Another Do's ... 0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom. Raj -- 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: Mercadante, Thomas F 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Wow, this statement... If you are a Decision Support database, then ARCHIVELOG is not needed. is one very broad and daring statement. [EMAIL PROTECTED] 02/24/03 09:03AM #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Thomas Day 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Hi, #8 - Don't Be a Normalization Bigot I would have written the above as Don't denormalise without good reason. To me denormalisation means that you must have a normalised design to begin with, in order to de-normalise it. I've seen a lot of designs where the designers have denormalised a set of tables to improve a perceived performance problem in one part of an application only to find out later that it adversely effected the performance of another part. The designers didn't even understand what the normalised design should be! I tend to find that starting with a normalised design is much more robust way to go. Cheers, Craig. -Original Message- Sent: Monday, 24 February 2003 9: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! -- 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: Craig Munday 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Maybe it depends on what you mean by a Decision Support database. I've supported types where a weekly batch upload of detail records was used to populate the tables, one database where the detail records on the OLTP database were programatically summarized and the summary data was used to populate the DSS, and a snapshot database (updated every 15 minutes) that duplicates the production database but allows various business analysts to run ad hoc querries from hell without impacting the production database. In the first 2 instances there are no inserts or updates after the batch load. The input data is saved. An archivelog would simply duplicate the input data. In the case of the snapshot (materialized view) database an archivelog hot backup recovery cannot bring the snapshot back into synchronization. You have to do a full rebuild. (I may be wrong about this and I'm willing to learn. It gives me the creaping willy-wallies that our only recovery is a rebuild.) There may be other types of decision support databases where an archivelog would be worthwhile. But are these truly DSS or is it a case of DSS and OLTP banged together into the same instance for some unfathomable reason. How would you physically tune such a monster? If archivelog is genuinely useful on your DSS database, then I would take that as a sign to begin disentangling your DSS from your OLTP. But I'll also admit that there's a lot I don't know. Darrell Landrum To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DLANDRUMcc: @zalecorp.com Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Sent by: root 02/24/2003 03:25 PM Please respond to ORACLE-L Wow, this statement... If you are a Decision Support database, then ARCHIVELOG is not needed. is one very broad and daring statement. [EMAIL PROTECTED] 02/24/03 09:03AM #4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?) My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file. Freeman Robert - IL FREEMANR To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tusc.com cc: Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments 02/23/2003 05:23 PM Please respond to ORACLE-L 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, 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! -- 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Darrell Landrum 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Robert, Thanks for sharing this... Sorry to chime in late (we got over 20 inches in the mountains this weekend!), how about Don't execute any day-to-day SQL manually more than once; plan for reuse by scripting it the first time? And, with all due respect, how about changing Do Monitor Your Database to Do Monitor Your Database Using Automatically Scheduled Scripts? Just my $0.02... Thanks again! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 3:23 PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Tim Gorman 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Actually, I have quite a bit of text associated with each of my 10 do's and don'ts... in the text of each, I actually state what you are saying. That is, that there are actually very few hard and fast rules about anything. For example with ASSM I suggest that in 9i it's probably not usable, and if you think you might benefit from it, test it first. So, I never discount anything totally. What I *believe* I've heard Cary say in the past was something to the effect that tuning LIO's will generally have a resultant impact on PIO's, and in the associated text that is the point I make. I am awaiting Cary's book with anticipation myself!!! I actually don't believe in anything hard and fast when it comes to this world known as Oracle. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 5:49 PM To: Multiple recipients of list ORACLE-L Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Darrell Landrum 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
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Interesting thoughts Tim! I shall consider changing those! RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 6:04 PM To: Multiple recipients of list ORACLE-L comments Robert, Thanks for sharing this... Sorry to chime in late (we got over 20 inches in the mountains this weekend!), how about Don't execute any day-to-day SQL manually more than once; plan for reuse by scripting it the first time? And, with all due respect, how about changing Do Monitor Your Database to Do Monitor Your Database Using Automatically Scheduled Scripts? Just my $0.02... Thanks again! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 3:23 PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Tim Gorman 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
This thread is great. Wish I was paying more attention to it. Here is one Don't Done rely on gui tools to accomplish any task. Great DBAs can endure the SQL to get the answer done. Good DBAs may opt for a GUI tool but will still use command line SQL first. Poor DBAs run for their GUI tools. Here is a DO Do always challenge yourself to find the solution. Do remember that other's have been through the same situation are available to help you. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Sunday, February 23, 2003 6:49 PM To: Multiple recipients of list ORACLE-L Subject:RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Darrell Landrum 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 contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
why #5 on the don'ts? I know we've had lots of discussions on this list about it, but I haven't seen anything that made me think never ever use that --- Freeman Robert - IL [EMAIL PROTECTED] wrote: Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
20 INCHES of snow WOW!! When I moved up to Chicago in January, I expected at least a little snow boy, weve gotten just little snippets of snow and that's it disappointing. Now I know where it's all gone! RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 6:04 PM To: Multiple recipients of list ORACLE-L comments Robert, Thanks for sharing this... Sorry to chime in late (we got over 20 inches in the mountains this weekend!), how about Don't execute any day-to-day SQL manually more than once; plan for reuse by scripting it the first time? And, with all due respect, how about changing Do Monitor Your Database to Do Monitor Your Database Using Automatically Scheduled Scripts? Just my $0.02... Thanks again! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 3:23 PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Tim Gorman 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
Well. ...this morning my wife looked around and harrumphed, It must have been a *MAN* who said this is more than 20 inches. :-) Can't imagine what she was referring to... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:53 PM 20 INCHES of snow WOW!! When I moved up to Chicago in January, I expected at least a little snow boy, weve gotten just little snippets of snow and that's it disappointing. Now I know where it's all gone! RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Sunday, February 23, 2003 6:04 PM To: Multiple recipients of list ORACLE-L comments Robert, Thanks for sharing this... Sorry to chime in late (we got over 20 inches in the mountains this weekend!), how about Don't execute any day-to-day SQL manually more than once; plan for reuse by scripting it the first time? And, with all due respect, how about changing Do Monitor Your Database to Do Monitor Your Database Using Automatically Scheduled Scripts? Just my $0.02... Thanks again! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 3:23 PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Tim Gorman 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
#0 - Do understand the business need(s) being met (along with business terminology). Being able to commincate technical information in terms that business decision makers use is critical for the business bottom line (and by extension - your own bottom line). Have Fun :) Freeman Robert - IL wrote: Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
You guys are very kind, thank you. My LIO vs PIO thesis is this: 1. Too many PIOs *is* a bad thing. 2. But eliminating unnecessary PIOs isn't enough. Even completely memory-resident databases can perform horribly (not scale, consume dozens of hours per query, etc.) 3. If you begin by eliminating unnecessary LIOs first, then you often eliminate all the PIOs you needed to eliminate, by side-effect. About the Top-10 list, I'll add... DON'T do something to make the system faster until you understand the impact that your proposed activity will have upon the response time of your important user actions. (Some proposed activities create negligible impact, and some even create negative impact. When you try those activities that don't create sufficient *positive* impact, then you *waste* your company's resources.) DO learn how to figure out--quickly, accurately, and inexpensively--the impact of a proposed activity upon end-user response time. 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- Landrum Sent: Sunday, February 23, 2003 5:49 PM To: Multiple recipients of list ORACLE-L Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [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: Darrell Landrum 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:
