Re: Help - Oracle not available on running catproc.sql in 9i

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 21 Mar 2004 07:42:54 +1100
Message-ID: <405cacd2$0$3957$afc38c87@news.optusnet.com.au>

"Sunit Joshi" <sjoshi_at_ingr.com> wrote in message news:8f8ffe67.0403200714.71c54572_at_posting.google.com...
> Thanks all...I suspected that and had modified it to 15MB and ran it
> again and it went fine this time.
>
> thanks again
> Sunit

No, you modified it to 16MB. Memory allocations on Windows come in 8MB multiples, as I mentioned last time.

And whilst catproc might have survived the experience, it is almost inevitable that you will encounter memory problems with such a small shared pool in the future.

If you're going to learn Oracle, then learn it right. Which includes making vaguely realistic memory allocations, and not making statements such as 'I modified it to 15MB' when it is utterly impossible to actually do that in 9i.

Are you short of memory on this XP box or something?

Regards
HJR Received on Sat Mar 20 2004 - 14:42:54 CST