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. ----- Original Message ----- To: <[EMAIL PROTECTED]> Sent: Monday, December 29, 2003 10:03 PM > Check profile option PRIVATE_SGA (available from 9i and needs resource_limit > parameter to be true). > > Tanel. > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> > > > Date: 2003/12/29 Mon PM 12:14:24 EST > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > 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: <[EMAIL PROTECTED] > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > > > **************************************************************************** > ********** > > > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, attorney > work product or exempt from disclosure under applicable law. If you have > received this message in error, or are not the named recipient(s), please > immediately notify corporate MIS at (860) 766-2000 and delete this e-mail > message from your computer, Thank you. > > > > **************************************************************************** > **********4 > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Jamadagni, Rajendra > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
