Yes, the parm was changed in 2000. pen_cursors = 300 max_enabled_roles = 30 db_block_buffers = 45000 buffer_pool_keep=(buffers:5200 lru_latches:2) shared_pool_size = 83886080 # shared_pool_reserved_size = 7M large_pool_size = 6291456 java_pool_size = 32K # java_pool_size = 53886080
These are the current values. I am new so there are no dumb suggestions. [EMAIL PROTECTED] wrote: > You mean the size parameter was changed in 2000, not to the value 2000? > Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB > or more. > > RWB > ============================================================================================================ > > Reginald W. Bailey > IBM Global Services - ETS SW GDSD - Database Management > Your Friendly Neighborhood DBA > 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) > ============================================================================================================ > > > [EMAIL PROTECTED] > edu To: [EMAIL PROTECTED] > Sent by: cc: > [EMAIL PROTECTED] Subject: ora-4030 out of memory error > ity.com > > > 06/23/2003 > 02:59 PM > Please respond > to ORACLE-L > > > > All - > > I have a user receiving this error on several different Unix boxes with > the same query. Oracle says to increase the size limit which was done > in 2000. The sort are size parm is set to 10485760. Any suggestions?? > > LeRoy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: LeRoy Kemnitz > 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: > 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: LeRoy Kemnitz 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).