Re: Hardware tips

How big is your SGA, particularly your DB Block Buffer pool? Sort Area Space? Multi-Block read count? Shared Pool size? These can have a bigger impact on performance than IDE. For a 768MB RAM system with 16 users you should be able to handle an SGA between 256MB and 512MB without difficulty (depending on transactions and table structure).

Also, remember that the SGA should not be swapped out. It is supposed to be resident, so be sure to check the OS virtual memory, etc.

Second consideration, two drives is 3 too few, ideally, unless you are dealing with something like EMC or a multiple channel controller. BUt, for only 15 users, the transactions should be too quick for that to be a major factor.

Third and most important, consider the table structure and transaction sql. Are you doing a lot of table scans? The usual ground rule is that performance is 70% application logic (including things like what are the indexes, etc.).

In article <912kjm$6o4$1_at_nnrp1.deja.com>,   Dennis <dwehlman_at_my-deja.com> wrote:
> I run Oracle 7 and 8 on a Sun Sparc 20 with 192 MB RAM and external
> disk pack. There was more than 15 users working with the instance at
> the same time with an OLTP application. And there was no problems.
> Is disk i/o slow down your system?
> Check swapping of your system.
> Check Oracle server parameters (buffers ...) in initSID.ora. Reduce
> memory allocation of Oracle if needed.
> I think it's not only your IDE disk slow down your system.
> Dennis
>
> In article <y12Z5.1073$pj.33475_at_news1.oke.nextra.no>,
> "Sindre Solem" <sindre.solem_at_emmaedb.no> wrote:
> > We're running Oracle 8.1.6 on a Sun Ultra 10, with 768 MB memory and
 to
> > disks. What we're finding is that the performance is unacceptably
 low
 for an
> > OLTP type application for up to 15 simultaneous users. Could this be
 because
> > it's and IDE based I/O system? Does anyone else have any experiences
 with
> > this server? Is it too much load for this server to handle?
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.