--- dist cash [EMAIL PROTECTED] wrote:
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
list,
comments
I like this - it nearly fits in, give or take a little
flexibility in interpretation, with my comments:
Tuning (engineering) is what you do before the system goes live
Trouble-shooting (science) is what you do after the system goes
live
Regards
Jonathan Lewis
Here' my fave...
1) DBA's are to create simple easy to follow with ample documentation..
with infrastructure work. In the long run it serves the company well
as well as your fellow dba's trying to support your work at 3:00am.
2) The work should be developed with a corporate perspective as
With the advent of quantum microbiology and the
like, most informed
people agree that 21st medicine is a science.
However, medicine as
practiced in the 17th century was definitely an
art, not a science. The
argument that tuning is an art--that it is
subjective like a
symphony or like cooking--is
ORACLE-L
[EMAIL PROTECTED]
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
Perhaps we depend to much on the force to guide and protect us at times...
:-)
Laugh you may, but in the last UK census (not a poll mind you but the actual
national census) 400,000 people indicated their religion was Jedi. This
was more than put their religion as Sikh, Jewish or Buddhist.
Of
telling us 'Why you don't agree on them?'
KG
--- dist cash [EMAIL PROTECTED] wrote:
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
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
list,
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800
Here is the list
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
list,
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800
Here is the list of top 10
Connor corollary to Wilson theory...
"The truth will out...especially when demonstrated with free beer!"
Freeman Robert - IL wrote:
And to the credit of Woodrow Wilson - "The wisest thing to do with a fool
is
to encourage him to hire a hall and
This reminds me of the paper I wrote for American Goverment in high school.
I don't recall the author, but the gist was that Free Speech must not be
impeded, because in the end, the Truth will prevail.
Very well said. Thank you Cary.
Cary Millsap wrote:
The only thing wrong with President
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
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
[EMAIL PROTECTED] wrote:
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
list
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
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 list,
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800
Here
You brought to mind another one... DON'T assume that changes in one
environment will have the same impact across all environments so DO
test the impact of any change in all environments that you can, before
implementing it in production. We had a change go in to the dev
environment that fixed the
-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
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
of list
ORACLE-L [EMAIL PROTECTED]
@tusc.com cc:
Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts
anyone - Here is my
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
list,
comments
Date: Mon, 24 Feb 2003 00:23:37 -0800
Here
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
ORACLE-L [EMAIL PROTECTED]
@tusc.com cc:
Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PROTECTED]
@tusc.com cc:
Sent by: rootSubject: RE: Top 10 DBA
Do's and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PM
Please respond
]
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
A... 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
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
PROTECTED]
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
recipients
of list ORACLE-L [EMAIL PROTECTED]
@tusc.com cc:
Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
recipients of list ORACLE-L
comments
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 list,
comments
Date: Mon, 24
PROTECTED] wrote:
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
list,
comments
Date: Mon, 24 Feb
Title: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Another Do's ...
0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom.
Raj
-
Rajendra dot Jamadagni
Oo, that *IS* a good one May need to add that to the list
somewhere somehow.
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
-
IL FREEMANR To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
@tusc.com cc:
Sent by: rootSubject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
:
Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts
anyone - Here is my list, comments
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]
#11: DON'T attempt to use OID 9.0.1 on Linux with Replication because it
DON'T work reliably!
#12: DON'T use CURSOR_SHARING=FORCE in versions below 8.1.7.4 without
expecting problems.
#13: DON'T work against your Duhvelopers and SysAdmin Nazis. You're all
working to the same goal (or should be).
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 management
I've had one too many experiences with but the environment is EXACTLY
the same only to find out that it isn't.
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
Oo, that *IS* a good one May need to add that to the list
somewhere somehow.
RF
Robert G. Freeman
Technical
thanks for the (Oh Ruby) reference. now it's stuck in my
mind.
-Original Message-
Sent: Monday, February 24, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
#11: DON'T attempt to use OID 9.0.1 on Linux with Replication because it
DON'T work reliably!
#12: DON'T use
:
Sent by: rootSubject: RE: Top 10 DBA Do's and Don'ts
anyone - Here is my list, comments
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 set
of list
ORACLE-L [EMAIL PROTECTED]
DLANDRUMcc:
@zalecorp.com Subject: RE: Top 10 DBA Do's and Don'ts
anyone - Here is my list
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
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
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
Actually, I have quite a bit of text associated with each of my 10 do's and
don'ts... in the text of each, I actually state what you are saying. That
is, that there are actually very few hard and fast rules about anything. For
example with ASSM I suggest that in 9i it's probably not usable, and if
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,
]
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
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
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
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, 2003
#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
You guys are very kind, thank you.
My LIO vs PIO thesis is this:
1. Too many PIOs *is* a bad thing.
2. But eliminating unnecessary PIOs isn't enough. Even completely
memory-resident databases can perform horribly (not scale, consume
dozens of hours per query, etc.)
3. If you begin by eliminating
52 matches
Mail list logo
