Re: Oracle 8i memory optimization

If you don't change sort_are_size from the default it is 64K. Jim

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3b00ff1b_at_news.iprimus.com.au...
> 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...
> > 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
> >
> >
>
>
Received on Tue May 15 2001 - 08:33:09 CDT