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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 20 Mar 2004 18:15:56 +1100
Message-ID: <405befb0$0$3955$afc38c87@news.optusnet.com.au>

"Sunit Joshi" <sjoshi_at_ingr.com> wrote in message news:8f8ffe67.0403192034.d7625fe_at_posting.google.com...
> I'm using 9.2 on WinXP-Pro-SVP1. This is what I have for memory config
> parameters in my ini.ora file:
>
> ## Memory configuration parameters
> db_cache_size = 25M
> shared_pool_size = 4M

Well, I'm not surprised you have trouble running catproc! It needs a shared_pool_size of at least 32M, and probably you'd be better off with 48M. The buffer cache is OK, although you should be aware that all memory allocations on Windows in 9i are in multiples of 8K, so in fact you'll have a 32M buffer cache.

Regards
HJR Received on Sat Mar 20 2004 - 01:15:56 CST