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: problems with memory

Re: problems with memory

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Wed, 9 May 2007 11:01:10 -0400
Message-ID: <1e52ad820705090801n91685ady5a8c5cf8c6ee310c@mail.gmail.com>


Do we know which process consumed high memry? What it was doing?

I have been using Auto Memory Management for a while now on our DSS DBs, without much issues. Only issue I have is when people do bulk collect with wrong limit/s.

Were you bable to identify the memory resizing within SGA? Do you know the PGAs used by different sessions when this happened?

On 5/9/07, Charles Schultz <sacrophyte_at_gmail.com> wrote:
>
> http://www.freelists.org/archives/oracle-l/08-2006/msg00748.html
>
> One of the linked notes references these metalink bugs:
>
> 4466399
> 4472338 (duplicate of the above 4466399)
> 4507532 (turned out to be a bad diagnosis, but the bug is real)
> 4920199
>
> Granted, these were under 10.2.0.1, and I have to admit we have not looked
> (yet) to see how they are addressed in 10.2.0.2 or 10.2.0.3. Oddly, doing
> a metalink search on these numbers returns zero hits. Very odd.
>
> On 5/9/07, Remigiusz Sokolowski <rems_at_wp-sa.pl> wrote:
> >
> > Charles Schultz wrote:
> > > My advice, based on practical experience, TURN IT OFF! (it = ASMM) I
> > > can dig up some metalink notes if you like. If I recall, I even posted
> > > a few notes here on the oracle-l list, and folks followed-up with
> > > their own thoughts. But save yourself the trouble and just turn it
> > off.
> > >
> > it is done already - our thought was ASMM is responsible as I have
> > written earlier. I just want to get into some details by curiosity - so
> > I'll be thankful for metalink notes if it is not big trouble for You
> >
> > btw. if it is so well known issue I apologize for starting this thread
> > Best regards
> > Remigiusz
> >
> > --
> > ---------------------------------------------------------------------
> > Remigiusz Sokolowski <rems_at_wp-sa.pl>
> > WP/PTI/DIP/ZAB (+04858) 52 15 770
> > MySQL v04.x,05.x; Oracle v10.x
> >
> > Zastrzezenie:
> > Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora
> > i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa
> > Wirtualna Polska S.A.
> > ---------------------------------------------------------------------
> >
> >
> >
> > WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP:
> > 957-07-51-216;
> > Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024zlotych (w calosci wplacony)
> >
>
>
>
> --
> Charles Schultz

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 09 2007 - 10:01:10 CDT

Original text of this message

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