Re: Please help - ORA 04030: out of process memory...

Thanks Sybrand,

I think the SGA was smaller than physical memory, the database was empty, no application yet. The pagefile growed when I ran the upgrade or in particular prvtaqis.plb in order to recreate one invalid object left after catproc.sql..

Also when I created a new database it was just a default template database - rather small even for my RAM...

Anyway thanks for your reply.

Henry

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:pfnpdvcob35rvo6f4sf7uovk41ipp5e3t4_at_4ax.com...
> On Tue, 03 Jun 2003 15:27:12 GMT, "Henry" <henry_2303_at_hotmail.com>
> wrote:
>
> >Hi,
> >
> >I'm getting this error (ORA 04030: out of process memory...) when I tried
to
> >upgrade existing 8.1.7 database to 8.1.7.2.1 and also when I tried to
create
> >new instance after I upgraded the server the server to 8.1.7.2.1.
> >
> >In the upgrade if fails during the catproc.sql. Few objects were invalid
> >after the script but I was able to recompile/rebuild most of them.
> >The one remained invalid - SYS.DBMS_PRVTAQIS. I have got the ORA 04030
again
> >when i tried to run prvtaquis.plb to recreate this package individualy...
> >
> >During the new instance creation with database assistant I got the same
> >error when addind plsql support - so it probably related to the same
problem
> >as in the first case...
> >
> >I tried to patch the server to 8.1.7.2.7 but it did not helped for this
> >case.
> >
> >I'm running Win 2000 on Pentium III 600MHz with 384MB Ram and the
pagefile
> >growed to 1.6GB during this steps.
> >I tried to install the same thing Pentium IV with 512MB RAM but same
> >thing... so it does not seem to be a lack of resources but rather some
leak
> >in Oracle...
> >
> >I'm thinking to to try higher version of Oracle but Application we are
using
> >is certified to 8.1.7.2 so I would rather avoid that.
> >
> >Does anyone has similar experience or have any suggestions how to proceed
?
> >
> >Thanks a lot,
> >Henry
> >
> >
> >
>
>
> 384 Mb of RAM is definitely nothing.
> Question how big is your shared pool in relation to the physical RAM?
> The best suggestion to proceed is to buy more RAM. If you have a 1.6
> Gb pagefile your SGA must be bigger than your physical RAM.
> If you are convinced this is a memory leak, rather than an ill-written
> application, you should upgrade to 8.1.7.4
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jun 03 2003 - 13:38:54 CDT