Re: pga_aggregate_target and a memory leak

Im assuming its his wait interface book. Ill get it as soon as it comes out. Hopefully it will be as good as his other tuning book. Is the April 12th date firm? Now the bigger question: Will it be out before the 10G database?

http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/qid=1074724628/sr=1 -2/ref=sr_1_2/104-1361632-8254324?v=glance&s=books ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 21, 2004 5:14 PM

>
> A comment I picked up from Tom Kyte's
> Masterclass in Copenhagen last week was
> that there is an effective limit of 1GB to
> P_A_T - and although a single session is
> supposed to be allowed 5% of the P_A_T,
> you could get about 90MB. So there are
> some funny things going on in that area
> which still need fixing.
>
> It's a bit tough for big systems, as I've
> found that the optimizer seems to be
> much smarter about memory user and
> access paths when P_A_T and W_S_P
> are set.
>
> What's the book about ?
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
> Next public appearance2:
> March 2004 Hotsos Symposium - Keynote
> March 2004 Charlotte NC - OUG Tutorial
> April 2004 Iceland
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK___February
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, January 21, 2004 7:44 PM
>
>
> > Replies in line...
> >
> > - Kirti
> >
> > --- Jared.Still_at_radisys.com wrote:
> > > Kirti, you're back!
> >
> > Thanks. Found some slack time from routine DBA work!
> >
> > >
> > > Must have finished the book. :)
> >
> > Not yet.. Its tough..
> >
> >
> >
> > >
> > > Re the PGA problems, what was the value for 'over allocation count' in
> > > v$pgastat?
> >
> > Actually, I never bothered to look at v$pgastat. Should have.. and will,
> when we do some more
> > testing next week..
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Ryan
  INET: ryan.gaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).