Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: (memory issue)Oracle 8.1.6 on NT 4.0
"NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
news:37bf1adc.24121935_at_news.earthlink.net...
> I think I have it set to 600K, don't remember how I came up with that
> #.
A small wager that you haven't. At least -despite 4 months of trying, I have been unable to start an 8i Instance with Java Shared Pool set to anything lower than 1M.
Have another look and get back to me (a sample from your init.ora would be useful).
Regards
HJR
> On Sat, 19 Aug 2000 22:09:13 +1000, "Howard J. Rogers"
> <howardjr_at_www.com> wrote:
>
> >
> >"Darrell Cooley" <Darrell_Cooley_at_med.unc.edu> wrote in message
> >news:399C26C8.BB054C19_at_med.unc.edu...
> >> I have just upgraded from Oracle 8.0.4 to 8.1.6.
> >> and I have notice a great increase in the amount
> >> of memory the oracle.exe is using. I currently
> >> have 256MB and since upgrading it is now using the
> >> majority of that. Is this to be expected or is
> >> there any tuning I can do to alleviate this.
> >
> >Watch out for the java pool. If you upgraded an old database, your
init.ora
> >wouldn't have an entry for this, so you'd be getting the default -which
is
> >20Mb. At this stage, you'll probably be wanting to use precisely zero of
> >this! Unfortunately, you can't switch the thing off entirely -the
minimum
> >appears to be 1M. But at least you can save yourself 19M of wasted
memory
> >by making an explicit declaration in the init.ora for
> >java_shared_Pool=1000000.
> >
> >In general, 8i is a lot hungrier than 8, and I would expect it to be more
of
> >a resource hog as a result.
> >
> >Regards
> >HJR
> >
> >
>
Received on Tue Aug 22 2000 - 04:12:01 CDT