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-----
[EMAIL PROTECTED]
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@artificia        To:     Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
                    l-life.ru>                        cc:
                    Sent by: [EMAIL PROTECTED]         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: [EMAIL PROTECTED]

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: [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.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

Reply via email to