Re: ora-4030 out of memory error

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).