Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: pga_aggregate_target and a memory leak

RE: RE: pga_aggregate_target and a memory leak

From: Arnold, Sandra <ArnoldS_at_OSTINET.osti.gov>
Date: Fri, 23 Jan 2004 16:54:25 -0800
Message-ID: <F001.005DE017.20040123165425@fatcity.com>


We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g.

Sandra

-----Original Message-----
Sent: Friday, January 23, 2004 5:39 PM
To: Multiple recipients of list ORACLE-L

i heard tom kyte speak in december. He said first quarter 2004 for solaris.

most people seem to still be on 8i. We have both 8i and 9i instance here. It will probably be a year before many employers are using it anywy.
>
> From: "Grabowy, Chris" <chris.grabowy_at_lmco.com>
> Date: 2004/01/23 Fri PM 03:24:45 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: pga_aggregate_target and a memory leak
>
> Kirti,
>
> So is April 12th the latest date you heard for when 10g "might" be
> released?? Because it was the end of 2003, but I didn't know it had
> slipped all the way into April...
>
> -----Original Message-----
> Kirtikumar Deshpande
> Sent: Wednesday, January 21, 2004 7:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks, Ryan.
> Yes, it is on OWI, for those who are new to OWI. Covers OWI from 8i to
> 10g. Co-authored with
> Richmond Shee and K.Gopalakrishnan.
>
> It will not be out till 10g goes production. Unfortunately, April 12th
> is not firm. 10g changes
>
> Regards,
>
> - Kirti
>
> --- Ryan <ryan.gaffuri_at_cox.net> wrote:
> > 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).
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: kirtikumar_deshpande_at_yahoo.com
>
> 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: Grabowy, Chris
> INET: chris.grabowy_at_lmco.com
>
> 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.gaffuri_at_cox.net
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arnold, Sandra
  INET: ArnoldS_at_OSTINET.osti.gov

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).
Received on Fri Jan 23 2004 - 18:54:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US