| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: large pl/sql table sucking up all memory on a server
Btw, PRIVATE_SGA only limits shared server SGA memory usage, for limiting
PGA sizes you could use _pga_max_size (defaults to 200M), but this is
getting kind of dirty and is unsupported (and works starting from 9i)
Tanel.
> Check profile option PRIVATE_SGA (available from 9i and needs
resource_limit
> parameter to be true).
>
> Tanel.
>
> ----- Original Message -----
> From: <ryan_oracle_at_cox.net>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, December 29, 2003 7:34 PM
> Subject: Re: RE: large pl/sql table sucking up all memory on a server
>
>
> > we dont have that level of granularity. everyone developers out of the
> same DBA account(not my call).
> >
> > any parameter settings to limit the size of pl/sql tables?
> >
> > >
> > > From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> > > Date: 2003/12/29 Mon PM 12:14:24 EST
> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > Subject: RE: large pl/sql table sucking up all memory on a server
> > >
> > > Assign the developer a "profile" .... that would do good.
> > >
> > > Raj
> >
>
> --------------------------------------------------------------------------
> ------
> > > Rajendra dot Jamadagni at nospamespn dot com
> > > All Views expressed in this email are strictly personal.
> > > QOTD: Any clod can have facts, having an opinion is an art !
> > >
> > >
> > > -----Original Message-----
> > > Sent: Monday, December 29, 2003 12:00 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > One of our guys used a very large bulk collect into with a forall
> update. It sucked up all the swap space on our solaris box and noone could
> connect to it. So we had to bounce the server.
> > >
> > > I was under the impression that pl/sql tables go into the buffer cache
> and cannot go large than its size? Oracle typically holds your hand with
> memory usage issues. Are there any parameter settings I can use that limit
> the size of pl/sql tables?
> > >
> > > Or are they just dynamic arrays that can grow as large as you want.
> > >
> > > I know your supposed to use a 'limit' command on them. I didnt write
it.
> I just dont want it to happen again.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: <ryan_oracle_at_cox.net
> > > INET: ryan_oracle_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: Tanel Poder INET: tanel.poder.003_at_mail.ee 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 Mon Dec 29 2003 - 14:24:25 CST
 |
 |