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

From: Alireza (delrish_at_gmail.com)
Date: 02/16/05

  • Next message: Rick Jones: "Re: Problem with bind/getsockname in 64-bit program." 
    Date: 16 Feb 2005 08:03:59 -0800

    Hi All,

    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.
    I installed a cluster 10g database. First I installed CRS and after
    that I installed oracle database. ( I want to test clustered database
    with one instance)
    I installed every thing line by line as oracle document wrote.
    All the things, kernel parameters, patches, are like oracle wrote in
    its document.
    I installed Golden quality package June 2004.
    I increased shmmax to 2.3 G . My SGA is 1.7 G And change some other
    parameters as Sandy Gruver wrote in Best Practices for Oracle on HPUX.
    I used oracle new storage system called ASM for this case.
    When I put the system under the load, I was monitoring the system
    carefully.
    I started gmp. When we sent some quarries to database (It is not heavy
    load, I tested it with a Linux system on proliant ML570 without any
    problem), suddenly DISK section in gpm changed to red (critical ) I
    read the warning. It said "Disk bottleneck probability = 100%". I
    changed the output of disk report to "Report IO by Disk"
    "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).

    Glance reported Disk was in Critical situation.
    I think the problem is IO or something about Disks
    I used HP Disk System 2405. Fibber channels on both server side and
    Disk Array side are configured at 2 Gb and topologies are
    PTTOPT_FABRIC.
    Is it ok that RAW IO RT about 1000 for each LUN?
    Why Disk% in glance/report IO BY Disk/ was 100%?
    I found an error in STM logs about I/O.It said:
    Entry type: I/O error
    Product: Fiber Chanel Interface
    Logger: td
    It logged this error about 12 times during the test.Any comment?

    Regards,
    Alireza

  • Next message: Rick Jones: "Re: Problem with bind/getsockname in 64-bit program."

    Relevant Pages

    • Re: Basic query tracing and profiling question...
      ... L: Oracle Logs 387GB ... # been enabled using ALTER DATABASE ARCHIVELOG. ... tablespace all on ONE disk is a recipe for disaster. ...
      (comp.databases.oracle.server)
    • Oracle and I/O performance.
      ... dba's are complaining about performance of importing a database export. ... another path to the SAN so that both volumes are on separate paths but I ... Oracle is running DirectI/O, asynchronous. ... An iostat on the two disks shows the bps and tps for the disk doing the ...
      (Tru64-UNIX-Managers)
    • Re: High Avg. Disk Queue Length When Opening Shared Calendars
      ... Let's assume 10K spindles, a 3:1 read/write ratio, and IOPS/user of 1. ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... A disk bottleneck on the database LUN. ...
      (microsoft.public.exchange.admin)
    • Re: Oracle Performance -- Possible Disk Bottleneck
      ... I've read that 15k drives can perform 180 IO's per second. ... confirm this is a disk bottle neck. ... so I'm hoping someone here has experience with SANs and ORACLE to help ... this is a disk bottleneck and that giving the database more spindles ...
      (comp.databases.oracle.server)
    • Re: Chaotic IMAP Message list
      ... bits of the database which are scattered about on your hard disk into a new ... break at an unfortunate location in the database. ... I was busy and didnšt read carefully so I thought you were advocating the more complete rebuild solution. ... or can you offer a thumbnail explanation of what happened and why a compact would fix it? ...
      (microsoft.public.mac.office.entourage)