Oracle-L: RE: RE: Top 10 DBA Do's and Don'ts anyone

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 24 Feb 2003 08:29:05 -0800
Message-ID: <F001.00556BC3.20030224082905@fatcity.com>

"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 Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           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?'

dist cash <mccdba_at_hotmail.com> wrote:
>
>
> I don't agree with "don't" #1 and #5.
>
>
>
>
> >From: "Stephane Faroult" <sfaroult_at_oriolecorp.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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: Rich.Jesse_at_qtiworld.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: Mark Leith
  INET: mark_at_cool-tools.co.uk

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:29:05 CST

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