RE: ORA-04030

128MB of memory is killing you! Oracle's stated minimum requirements are 128MB (but they recommend 256MB). In fact, the Oracle Installer won't even run without 128MB (in 8.1.6 and higher).

Ed Haskins
Oracle DBA
Verizon Wireless

-----Original Message-----
Sent: Monday, April 23, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L

What did you try and resize it to? Remember, you only have 128 mbs.

-----Original Message-----
Riyaj_Shamsudeen_at_i2.com
Sent: Monday, April 23, 2001 12:02 PM
To: Multiple recipients of list ORACLE-L

How big is your shared pool size ? Do you have many dynamic SQLs ? You may want to keep the sys packages in the shared pool, so that your shared pool won't be fragmented by dynamic SQLs.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com

                    "Dorozhkin, Anton"
                    <Anton.Dorozhkin_at_artificia        To:     Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
                    l-life.ru>                        cc:
                    Sent by: root_at_fatcity.com         Subject:     ORA-04030


                    04/21/01 07:05 AM
                    Please respond to ORACLE-L

I've got a such error when run a PL/SQL scripts on Windows 2000, Orcale 8.1.7 with 128MB memory

ORA-04030: out of process memory when trying to allocate 257280 bytes (PLS non-lib hp,PAR.C:parchk:ptb)

I've tried to change settings in init.ora but this didn't help.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dorozhkin, Anton
  INET: Anton.Dorozhkin_at_artificial-life.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author:
  INET: Riyaj_Shamsudeen_at_i2.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: 
  INET: Ed.Haskins_at_VerizonWireless.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).