Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: (memory issue)Oracle 8.1.6 on NT 4.0

Re: (memory issue)Oracle 8.1.6 on NT 4.0

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 21 Aug 2000 21:29:15 GMT
Message-ID: <37bf1adc.24121935@news.earthlink.net>

I think I have it set to 600K, don't remember how I came up with that #.
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 Mon Aug 21 2000 - 16:29:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US