Re: Oracle 8.1.6.0.0 performance boost options

Randall,

The worst performance problem is with the Administrator application (there are also applications for order preparation for jog dispatching, which are problematic, but not seriously so). Setting SORT_AREA_SIZE on a session basis could just do the trick.

Mark

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 - 12:04:28 CDT