Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i memory optimization
A version would be good. In 8.1.6 and above, the java pool can come down to 32K, and save you 10M.
Depends on your application but (batten down the hatches for the flames) I would ordinarily expect the Shared Pool to be bigger than the buffer cache, not the other way round. Similarly, I'd expect the sort area size to be more like 1Mb than 64K (but if you only ever do small sorts, may be not).
The short (but truthful) answer really is that until we see your report.txt, or some v$ output, it's practically impossible to say one way or another.
Regards
HJR
-- =============================!!============================= The views expressed are my own only, and definitely NOT those of Oracle Corporation =============================!!============================= "Jon" <jzuazoa_at_nexo.es> wrote in message news:9dqjpp$30f$1_at_unbe.sarenet.es...Received on Tue May 15 2001 - 05:04:01 CDT
> Hi,
>
> I know this question may be difficult to answer because you will need more
> information but I would like to know, aproximatelly, the way you share the
> physical memory of the oracle instace between the different posibilities
> avaible.
>
> I can use about 512MB of RAM memory so as to be used by a database that
> serves a typical client/server application. The database does not use java
> and server stored procedures. Ask me please if you need more information.
>
> Now I am using the following memory parameters:
>
> Shared Pool -> 100 MB
> Buffer cache -> 200 MB
> Large Pool -> 3 MB
> Java Pool -> 10 MB
>
> Max. Users -> 100
> Sort Area Size -> 64 KB
>
>