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: sfaroult_at_oriolecorp.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).