The ORA 4030 is about a process not having enough
room.
It's been a bug on Oracle (Oracle 8.0.5 on hpux 10.20
had that) or your opening a cursor in a loop and
you're forgetting to close it or something similar.
- Kevin Kostyszyn <kevin_at_dulcian.com> a écrit : >
Acutally, 8.1.5 won't install either. I mean it
> will, but it will tell you
> that it is a bad idea.
> Kev
>
> -----Original Message-----
> Ed.Haskins_at_VerizonWireless.com
> Sent: Monday, April 23, 2001 2:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
> --
> 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).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping :
http://fr.shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.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).
Received on Tue Apr 24 2001 - 01:55:56 CDT
