| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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!!!!
<FONT face=Arial color=#0000ff
size=2>
May be
some one know why it happend???
<FONT face=Arial color=#0000ff
size=2>
Thanks
a lot.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Anton.
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lkoivu_at_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 <FONT
size=2>Oracle Database Administrator Certified
Self-Important Database Deity Slayer of Unix
Administrators Wanton Kickboxing Goddess
lkoivu_at_qode.com
NeoMedia
2201 Second St., Suite 600 Fort
Myers, FL 33901, USA Phone: 941-337-3434
Fax: 941-337-3668 www.neom.com <<A
target=_blank href="http://www.neom.com">http://www.neom.com>
www.paperclick.com <<A target=_blank
href="http://www.paperclick.com">http://www.paperclick.com>
www.qode.com <<A target=_blank
href="http://www.qode.com">http://www.qode.com> <FONT
size=2> P a p e r C l i c k . c o m <<A
target=_blank
href="http://www.paperclick.com/home.htm">http://www.paperclick.com/home.htm>
Enter Your PaperClick Code Here! <FONT
size=2>
-----Original Message----- From:
Dorozhkin, Anton [<A
href="mailto:Anton.Dorozhkin_at_artificial-life.ru">mailto:Anton.Dorozhkin_at_artificial-life.ru]
Sent: Saturday, April 21, 2001 8:05 AM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>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.
 |
 |