Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.6.0.0 performance boost options
Randall,
Thanks for the suggestion.
Mark
_SIZE Randall Roberts wrote:
> The first thing I'd try is increasing SORT_AREA_SIZE. This will reduce
> swapping of sorts to disk. If you increase it large enough none of the sort
> will have to swap to disk. The parameter is dynamic and can be set at the
> instance or session level. I'd recommend that you set it at the session
> level, so that you don't increase the PGA size for every server process on
> your system... unless of course everyone on your server is running these
> queries.
>
> Best!
>
> Randall
>
> Mark Tompkins <mdtompkins_at_home.com> wrote in message
> news:3B0C4AC9.16195D4A_at_home.com...
> > Hi,
> >
> > We have a current production db installation running Oracle 8.1.6.0.0
> > running on an HP Netserver LH3 with 512 MBytes RAM and 3 drives for the
> > Oracle Db mirrored.
> >
> > We have performance problems, with queries that are not using indexes,
> > sometimes because they access views, and indexes are not used (tempdb).
> > The temp db access appears to overload the cpu.
> >
> > 1. We may not have time to fix the bad sql. Is installation of a RAM
> > disk for tempdb a viable alternative to speed up the temp db access, and
> > also reduce load to the CPU?
> >
> > 2. The hardware is 3 years old. With the newer smart scsi, how much
> > speed improvement can be had, simply by upgrading hardware? Any
> > interesting comments?
> >
> > 3. What about Linux vs NT? I know Oracle won't publish TPC benchmarks
> > by OS. However, there must be some way to figure out which is better,
> > and by how much.
> >
> > thx
> >
> > Mark
> >
> >
Received on Thu May 24 2001 - 11:51:41 CDT