erm apparently Melanie didn't present there. my mistake.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:403d0de1$0$9747$cc9e4d1f_at_news.dial.pipex.com...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:hPZ_b.75578$Wa.6870_at_news-server.bigpond.net.au...
> > "Ron" <support_at_dbainfopower.com> wrote in message
> > news:rt6dncyYOeUe5qbdRVn-uw_at_comcast.com...
> > >
> > > ...<blah><blah>,<blah>
> > >
> > > When you was helping to crucify Don Burleson on this forum you
cared
> > > only for technical correctness, and ignore that many DBAs would take a
> > word
> > > from Burleson vs all your life story and all technical advice you can
> > > provide in a future 10 lifes.
> > >
> >
> > Funny you should mention that dear Ron as your buddy Don Burleson has
been
> > up to his old tricks again.
> >
> > Someone mentioned to me that only a couple of weeks ago at the RMOUG
> > conference, Don yet again publicly embarrassed himself by stated that
both
> > db_keep_cache_size and db_recycle_cache_size is a sub-pool of the
> > db_cache_size (http://www.rmoug.org/TD2004_Pres_Sum.htm). Despite
Oracle9i
> > being out for over two years, Don still believes that the Default Pool
> size
> > is calculated as db_cache_size - db_keep_cache_size -
> db_recycle_cache_size
> > !!
>
> Cheers Richard
>
> so we have the likes of Cary Millsap, Dan Fink, Melanie Caffrey, Bill
Thater
> et al presenting at RMOUG
>
> and then of course we have such classics in addition to the ones you
> mentioned as
>
> .Whenever the value of the v$sysstat statistic "workarea executions -
> multipass" is greater than 1%, the database may benefit from additional
RAM
> memory.
>
> or
>
>
> Now, for the first time ever, we can see the
> Internal RAM usage for SQL statement execution
>
> the second keep pool
>
>
> 1.db_2k_cache_size - Secondary KEEP po
> and of course
>
>
> Part of my job is to spy on DBAs:
> YClandestine DBA evaluations
> so pay close attention
>
> what fantastic stuff, though to be fair the same person who is telling me
to
> pay attention to his methods becuase otherwise my employer might employ
him
> to 'spy' on me is also offering repeatedly to 'mentor' me in spams I never
> knowingly signed up for.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
>
>
Received on Wed Feb 25 2004 - 17:44:44 CST
