RE: OT: Reading the Oracle Tea Leaves

I liked the O'Reilly book, but don't know if they updated it for 8i - time to do it soon, if it hasn't been done! 9i is coming this summer...

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Lord David [SMTP:dlord_at_haysits.co.uk]
        Sent:   Friday, April 27, 2001 5:55 AM
        To:     Multiple recipients of list ORACLE-L
        Subject:        RE: OT: Reading the Oracle Tea Leaves

        Well, we run lots (70 odd) of smallish (4-16Gb) databases that
usually don't
        need a lot of tuning.  Hence, if we do have to tune something, its a
real
        pain because we don't have the experience of doing it every day.
So, as far
        as I'm concerned, roll on autotuning.  There's plenty to keep us
occupied at
        'higher' levels.

        However, on the 'career' front, I'd like to learn more, so could
anybody
        recommend a good book on tuning?

        TIA
        David Lord

        -----Original Message-----
        Sent: 26 April 2001 23:16
        To: Multiple recipients of list ORACLE-L


        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
        ian_at_slac.stanford.edu

        OCP Oracle8 DBA
        iNetProfit, Inc.
        Austin, Texas
        www.iNetProfit.com
        japplewhite_at_inetprofit.com
        (512)327-9068



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

        Ian MacGregor

        -- 
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        -- 

        
**********************************************************************
        This email and any files transmitted with it are confidential and 
        intended solely for the use of the individual or entity to whom they

        are addressed. If you have received this email in error please
notify 
        the system manager.

        This footnote also confirms that this email message has been swept
by 
        MIMEsweeper for the presence of computer viruses.

        www.mimesweeper.com
        
**********************************************************************
        -- 
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        -- 
        Author: Lord David
          INET: dlord_at_haysits.co.uk

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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