Gentlemen your Unix is showing. There are definite problems with Process
memory in NT. In NT all of the Oracle user processes are part of the
oracle.exe. Separate processes for the users does not exist. Therefore all
user memory needs come out of the system memory pool. There is loads of
info about this on metalink and in technet. Do some reading there. Patching
is not going to fix your problem.
Liz
"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 Wed Jun 04 2003 - 10:59:57 CDT
