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

Thanks all...I suspected that and had modified it to 15MB and ran it again and it went fine this time.

thanks again
Sunit

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<405befb0$0$3955$afc38c87_at_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 - 09:14:28 CST