Re: OT: Reading the Oracle Tea Leaves

IMHO, this is just a marketing gimmick.
Auto-tuning won't work on DB for the same reason it doesn't work at the OS level:
the system will spend more time tuning itself to cope with occasional glitches than it will doing work. Watch what happens with NT for a good example of this problem. It's a known problem of feedback systems, which is what you need to do auto-tuning.

You can find a solution that tunes for the middle of the road, but unless you freeze it, it won't work anywhere as well as they promote it.

Known problem, ages old, no solution.
Mathematically and in practice.

It will just be a nice to have for all those IT managers out there looking at excuses to "downsize" the really competent people in their organisations: usually the DBAs and the Sys Admins. It's rubbish and will never fly, but it will go down well with those who only analyze $$$ results in the short term.
Just another fad. Looks good for the "TCO"...

Doesn't affect me at all, but I find it
quite amusing! :-)

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au
http://www.users.bigpond.net.au/the_Den
----- Original Message -----
> Past history forces me to disagree. If it takes Oracle as long to
"perfect"
> AutoTuning as it has to "perfect" the Cost Based Optimizer, DBAs
will
> continue to be in demand for decades to come!
> >>> ian_at_SLAC.Stanford.EDU 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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nuno Souto
  INET: nsouto_at_nsw.bigpond.net.au

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: 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).