I didn't assert that DBA's will become expendable, nor did I state a timeframe for
when autotuning will become a usable option. I doubt autotuning will ever be perfect,
but any DBA who thinks he is, has a vainglorious opinion if himself.
I believe in the fullness of time, between 5 and 10 years, autotuning will be good
enough for at least 80% of the Oracle databases. We tune based on our expericences
and on the experiences of others. Many of these experiences could be codified as
rules. We also fine tune our "rules" or derive new ones as new situations arise. I
doubt autotuning will be doing the five or ten year period.
If you think autotuning is a death knell, keep in mind here is more to being a DBA
than changing init.ora parameters and that the skillset required will change over
time.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
>>> [EMAIL PROTECTED] 04/25/01 06:36PM >>>
I foresee the database being sold as a turn key product configured by Oracle
at a reduced price. In order to receive the discount the purchaser would
have to agree not to mess with the init<SID>.ora parameters, nor take any
action which would enable or disable any database options. "What?!, not
change init.ora parameters", you scoff. Remember that Oracle 9i has some
autotuning capability. I expect, at first, autotuning will not work as
advertised, but over time will mature into a powerful product.
Ian MacGregor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
