From Anton.Dorozhkin@artificial-life.ru Wed, 25 Apr 2001 10:50:25 -0700 From: "Dorozhkin, Anton" Date: Wed, 25 Apr 2001 10:50:25 -0700 Subject: RE: ORA-04030 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: ORA-04030 Hi All ! Thanks for help, I think i solve the problem, but I don't understand why it began work. I increased size if shared poll up to 100MB, but part of script doesn''t began work in SQL Plus but it starts work in SQL Navigator!!! So I run whole script in svrmgrl and it's didn't show me an error!!!!   May be some one know why it happend???   Thanks a lot.   Anton.
-----Original Message-----From: Koivu, Lisa [mailto:lkoivu@qode.com]Sent: Monday, April 23, 2001 5:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-04030 Hi Anton - The error is exactly what it says it is. The OS is out of memory to allocate to this once process. Are you using PL/SQL tables or anything that could go wild with memory in your PL/SQL scripts?  I've had this happen before when I first started messing with PL/SQL tables. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess lkoivu@qode.com    NeoMedia   2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com <http://www.neom.com> www.paperclick.com <http://www.paperclick.com> www.qode.com <http://www.qode.com>   P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm>    Enter Your PaperClick Code Here!     -----Original Message----- From: Dorozhkin, Anton [mailto:Anton.Dorozhkin@artificial-life.ru] Sent: Saturday, April 21, 2001 8:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-04030 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@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@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).