Re: BUFFER BUSY WAITS

To which I add my voice in total agreement.

If you aren't finding things of value ... perhaps you are looking in the wrong place for enlightenment. <g>

Daniel Morgan

Bricklen wrote:

> Do a search through the usenet archives and I think you'll find that
> Nuno has contributed some very insightful and valuable information in
> previous posts. I've always found his posts thoughtful and they
> generally bring a grin to my face.
>
> Cheers,
>
> Bricklen
>
> Keld Nielsen wrote:
> >
> > You and your 'doodled thusly' !
> >
> > When do you start to contribute with something which is of any use in this
> > forum ?
> >
> > "Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
> > news:3c723412.4660994_at_news-vip.optusnet.com.au...
> > > Ricky Sanchez doodled thusly:
> > >
> > > >1. Take the Rich Niemic book and toss it in the trash. The man is a
> > > >complete idiot.
> > >
> > >
> > > thank you. I thought that too, but I've been told by local "powers
> > > that be" at Oracle Professional Services that he's God and anyone else
> > > from TUSC is an archangel.
> > > Mind you, this was a few years ago when anyone from Australia was
> > > "rubbish" and anyone from overseas was God.
> > > That has changed somewhat too (thanks, SA!). And about time.
> > >
> > >
> > > >Data/Index: Poor application design is probably the issue. Most likely
> > > >snip of good stuff.
> > > >value. You might also have too many indexes. If so, analyze the
> > > >application and get rid of some indexes.
> > >
> > >
> > > or if you're faced with a third party app where you can't change a
> > > thing without breaking the "warranty", whatever that means nowadays
> > > (Peoplesoft and others spring to mind):
> > >
> > > look at speeding up access to these index blocks by splitting your
> > > buffer cache using the DEFAULT/RECYCLE/KEEP mantra and allocating
> > > "problem" indexes to the right cache. Highly dependent on nature of
> > > table usage which of RECYCLE or KEEP one uses.
> > >
> > > >
> > > >And get rid of that Rich Niemic crap.
> > > >
> > >
> > > hope you got a good backing, and agreed.
> > >
> > >
> > > Cheers
> > > Nuno Souto
> > > nsouto_at_optushome.com.au.nospam
Received on Tue Feb 19 2002 - 15:01:58 CST