RE: 10g ADDM: Threat to DBAs?
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxx>
- To: <gkatteri@xxxxxxxxxxx>, <lambu999@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 6 Mar 2006 15:26:50 -0800
Ram,
I agree with Govindan on this. There are just too many things that a DBA
has to do which an automated system such as ADDM cannot do as well. But
if you look at the features that Oracle (and other vendors as well) have
introduced over a period of time (and not just in 10g) helps you as a
DBA achieve some level of efficiency. For example, the simple AUTOEXTEND
in 8i (?) helped you to sleep better and grow a datafile automagically,
and resumable transactions in 9i helped you by suspending a runaway job
that even exceeded the extra automatic growth. 10g extended that even
further and provided a Segment Advisor for object growth trending. But
these did NOT replace a DBA!
What these new features and cool stuff did do however, was to provide a
higher level of operating efficiency so you can pander to damagement's
"do more with less" mantra (as in "manage more databases with less
DBAs"). This was happening anyway, so these new features come in handy
*BUT* ONLY when (a) you understand the business and its needs and (b)
understand and implement these features for the _right_ reasons and in
the _right_ manner. And that takes some experience, something that
cannot be expected from a "SQL-Server DBA who was used to
<LeftClick><RightCLick><OK> turned Oracle Expert".
Certainly today's DBA needs to read a lot more and understand a lot more
technology than even a decade ago. And the range is so vast so no one
can claim to be an expert in everything (JL, Steve and other Gurus
excepted!)
On the flip side, in my previous job we went from 45 Databases to 70-odd
within three years with no increase in DBA staff, and in another one, we
went from 30 databases to 120 databases in three years with a 70%
reduction in staff. This could only be done with a cohesive, consistent
and deliberate move to automate as much as possible, using new features
as much as possible, reading/understanding/testing and applying
knowledge that was learnt daily. (Have a look at Chapters 10 through 13
in the book noted below if you want to understand and extend what 10g
does in this area!)
My 2c!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Co-Author: Oracle Database 10g Insider Solutions
http://www.amazon.com/exec/obidos/tg/detail/-/0672327910/
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GovindanK
Sent: Monday, March 06, 2006 7:04 AM
To: lambu999@xxxxxxxxx; oracle-l
Subject: Re: 10g ADDM: Threat to DBAs?
ADDM is no substitute from experience and intelligence. It can augument
your thought process though.
HTH
GovindanK
On Sat, 4 Mar 2006 18:04:45 -0500, "Ram K" <lambu999@xxxxxxxxx> said:
Hello gurus,
I searched on this list for ADDM. I did not find the answer on this
topic.
Are ADDM and its successors going to put DBAs out of jobs? or reduce the
number of DBAs required? I read about it online in one site that the
dependency on DBAs for tuning might end soon.
--
Thanks,
Ram.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
