Re: Oracle 10g on HP-UX, Terrible Poor Performance!!

From: Lars Bausch (lars.bausch_at_dotsch.de)
Date: 02/16/05

  • Next message: Otto Lind: "Re: Problem with system() calls in a multithreaded program on HPUX 11" 
    Date: Wed, 16 Feb 2005 22:00:44 +0100

    Hi !

    Lars Bausch wrote:
    >> I setup an Oracle 10g on HP-UX 11iv1. Server is a HP 9000, 4 CPUs (750
    >> MHZ). It is connected to Disk System 2405 (Virtual Array 7110). Fiber
    >> Channels are connected at 2 GB speed.
    Ahm, you mean a DS2405 not a VA7110 ? - this are two different types of
    arrays. The 2405 is a JBOD and the VA7110 is a RAID array with
    virtualisation in RAID10/RAID5 or RAID5

    >> "DISK%" was 100% and "RAW IO RT" was about 1000 for two disks ( This
    >> two disks dedicated for ASM). In this situation CPU idle time was 1% or
    >> 2% for all the CPUs but load average was about 1. Performance is not
    >> acceptable at all ( In comparison with Oracle that installed on Linux).
    If you need high performance, you better use a lot of disks for your db.
    I think, in these config the disk array can be the greatest bottleneck.

    Lars

  • Next message: Otto Lind: "Re: Problem with system() calls in a multithreaded program on HPUX 11"

    Relevant Pages

    • Re: building on your own a large data storage ...
      ... RAID-5 array because doing I/O on two devices on the same IDE ... primary IDE port and one on the secondary IDE port. ... understanding the trade-offs (partioning an array of disks vs. ... When a fan goes ...
      (comp.sys.ibm.pc.hardware.storage)
    • Re: Clustering Newbie - SAN Advice
      ... I have not used that particular unit, bit it does meet my basic criteria of having the controllers and cache on-board the array. ... Senior SQL Infrastructure Consultant ... A SAN generally has gigabtes of cache and uses large internal block sizes ... The SAN or Smart array will dictate what internal connection the disks have. ...
      (microsoft.public.sqlserver.clustering)
    • SUMMARY: Network attached storage ideas
      ... Let me start by clarifying that the issue with Solaris ... and NFS is not with Solaris but with how the Snaps ... 3310/3311/3510 array). ... more expensive SCSI or FC disks. ...
      (SunManagers)
    • Re: New disks in 7026
      ... Subject: New disks in 7026 ... Would I create a second array with these two disks? ... drives as non-array drives, but not add to an existing array. ... Array -> IBM PCI SCSI Disk Array -> PCI SCSI Disk Array Manager, ...
      (AIX-L)
    • Re: Help needed - RAID5 recovery from Power-fail
      ... This array of 2 * 250GB disks was set up as RAID5 with the aim of adding another drive later. ... Raid Devices: 2 ... Failed Devices: 2 ...
      (Fedora)