Re: Mirroring on 10.10

Steve,

        From my experience, most of the Oracle databases seem to be more i/o intensive than cpu intensive. Implication: multi-processor units don't get that much performance gain.

1. Are you Mirroring across I/O channels?!
2. Can you use the System F/W controller, as an additional i/o channel?!
3. Have you tried it without the mirroring (Mirroring does slow things down by a lot).
4. Are you using SWAP? if so, can you either get more memory, or cut the swap disks across multiple drives?!
5. Can I safely assume that you're cutting your databases across the disks?
6. Have you considered cutting a few gigs as strip drives?! and use that drive as your index/temp file drive?! where the un-important data sets?! (Strip drives can be 5 times as fast as mirrored drives) Reply back.. let me know how it works out.
   • howard

Steve Holdoway wrote:
>
> We have just taken delivery of a 5 processor T520, running HP-UX
> 10.10. The system is set up such that we have a 4 gig system disc on
> its own F/W controller, and 14 x 2 gig discs mirrored over 4 extra F/W
> controllers. This is being used mainly to access an Oracle 7.2.3
> database.
>
> Initial results indicate much less of a performance increase from the
> single processor D350 that is used for development. This machine is
> set up to use asynchronous IO and the kernel is configured as
> recommended by HP and Oracle.
>
> Using glance, the machine seems to have no bottlenecks anywhere, is
> just doesn't seem to be running at its full potential. I suspect that
> it is the disc mirroring that is the problem. Do I need to rejig the
> kernel for that as well?
>
> Any suggestions will be extremely gratefully received... explaining to
> out customer just why they need this machine when it doesn't work to
> its full potential could be very embarassing!
>
> TIA
>
> Steve.
Received on Tue Jul 23 1996 - 00:00:00 CEST