| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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" <Stephen_Karniotis_at_compuware.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: Stephen.Karniotis_at_Compuware.com
>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
>
>
>
> >>> FREEMANR_at_tusc.com 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: FREEMANR_at_tusc.com
>
>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: ListGuru_at_fatcity.com (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: dlandrum_at_zalecorp.com
>
>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: ListGuru_at_fatcity.com (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: Stephen_Karniotis_at_compuware.com
>
>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: ListGuru_at_fatcity.com (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: david davis INET: ddoralist_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Mon Feb 24 2003 - 10:24:13 CST
 |
 |