RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

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