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
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 manageme
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
cc:
Sent by: root Subject: RE: Top 10 DBA Do's and Don'ts
anyone - He
Freeman Robert -
IL
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/2
rt -
IL
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PM
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
week, and
> if everything is still running OK then delete the renamed file.
>
>
>
>
> Freeman Robert -
> IL
> @tusc.com> cc:
> Sent by: rootSub
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PM
Please respond
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's and Don'ts
anyone - He
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
>
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 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 Moni
#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 wro
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,
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 ww
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 Ex
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, Febr
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 Da
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 Da
20 matches
Mail list logo