Re: sql tuning

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:2%Jk9.40569$g9.117078_at_newsfeeds.bigpond.com...
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:MgDk9.40464$g9.116924_at_newsfeeds.bigpond.com...
> > Hi Norman,
> >
> > Memories ...
> >
> > The 9i New Features course was the last course I taught at Oracle. It's
> > actually one of the better new feature courses in that it's a
comfortable
> 5
> > days worth of material (rather than the usual 8 days worth in 5).
> >
> > Howard feels very strongly about ASSM, he absolutely loves it and
> considers
> > it one of the most significant advances in Oracle database technology ;)
>
> Now, now: in its place, I'm sure it could have a use. I'm just not sure
what
> that place is yet!
>
> In a RAC, where freelist contention is horrendous, I imagine it might be
> worth a look. But, as Jonathan pointed out to me the other day, the index
> consequences can be awful, so best to have several extra tens of gigabytes
> of hard disk on hand. And pray you aren't doing full table scans.
>
> >
> > I sense a shovel load of 'horse manure' on it's way o:)
> >
>
> Nah, only when excrement of another kind is posted first. Which you never
> do.
> (Though references to a certain "pop singer" come close!!)
>
> ;-)
> HJR
>
>
>
> > Richard
> >
> > "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> > news:E2F6A70FE45242488C865C3BC1245DA702B35F79_at_lnewton.leeds.lfs.co.uk...
> > > Hi Richard,
> > >
> > > please feel free to second the nomination - the more votes the better
!
> > >
> > > Just back from 9i new features - some intersting stuff in there !!
> > >
> > > I'm sure Howard will have things to say re ASSM and UNDO TABLESPACES
:o)
> > >
> > > Cheers,
> > > Norman.
> > >
> > > PS. I still have a lot of catching up to do on current threads - but
no
> > > time to do so :o(
> > >
> > > -------------------------------------
> > > Norman Dunbar
> > > Database/Unix administrator
> > > Lynx Financial Systems Ltd.
> > > mailto:Norman.Dunbar_at_LFS.co.uk
> > > Tel: 0113 289 6265
> > > Fax: 0113 289 3146
> > > URL: http://www.Lynx-FS.com
> > > -------------------------------------
> > >
> > >
> > > -----Original Message-----
> > > From: Richard Foote [mailto:richard.foote_at_bigpond.com]
> > > Posted At: Wednesday, September 25, 2002 2:26 PM
> > > Posted To: server
> > > Conversation: sql tuning
> > > Subject: Re: sql tuning
> > >
> > >
> > > Hi Norman,
> > >
> > > Can I please second this nomination.
> > >

I've no idea which is the best book, but I'd like to congratulate the original poster for starting in the right place (thread may be lost, but see the subject!).

I am, moreover, absolutely sure that Nuno will concur.

Cheers,
Paul

P.S. Nuno, one needs your 'Bingo!' remark again, if one is to retain credibility. Received on Fri Sep 27 2002 - 19:10:16 CDT