Re: OT: Reading the Oracle Tea Leaves

If you want to tune SQL, get Guy Harrisons book on tuning Oracle SQL.

It is the best document available for that.

Some books I've heard are very good, but can't recomment cuz I haven't read em yet are Jonathan Lewis book, 'Oracle 24x7', and 'Unix Oracle Tuning'

Sorry don't have exact names, but they're easy to find on amazon.

If you really wanna get into the internals of tuning, get Steve Adams book 'Oracle 8i Internal Services'. Very detailed. Be prepared to read everything 3 or 4 times, it gets pretty hairy at times. :)

Jared

On Friday 27 April 2001 01:55, Lord David wrote:
> 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
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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