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

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

Date: Thu, 17 Feb 2005 20:44:55 +0100

Hi !

Alireza wrote:
> Thank you Lars,
>
> The storage in Linux enviroment is Filesystem.It does not connect to
> any Storage system. it use its local scsi 10k hard disk for storage. i
> think SAN should be more faster that local hard disk.
Yes.

> CRS stands for Cluster Ready Server, developed by oracle in 10g version
> . It is required for setup RAC system (Real Application Cluster).
> ASM is oracle new storage system, introduced in 10g version.Oracle
> recomends to use ASM for storage in most of its documents.
> ASM is like Raw Device. It does not need file system or LV at all. You
> just creat LUNs in Disk Array and assign it to Oracle.
Ah. Thanks !

> In front of My disk Array wrote "HP Disk System 2405" but when i
> connect to serial port of it and monitor the boot processing, it writes
> Virtual Array 7110.
> It has 2 ports on Disk Array. one of them is for using in Jbod mod
> another can connect to SAN Switch. I connect it to SAN switch.
Hm, it is an new aspect.
Can you verify in witch RAID Mode your Array is configured. The VA can
do RAID10 and RAID5 DP in autoraid, and RAID 5 DP.
In autoraid mode the VA keep, if space is available, data in RAID10 for
performance. For example offen accesed data.
But if you have assigned most of your space to luns, the array will
migriate the data from RAID10 to RAID 5 online. High RAID5 and low
RAID10 usage decreases performance.

Have you install commmand view sdm, for administration tasks on the
array ?
With the GUI, you can easly administate the array. In the performance
menu from the GUI, you can read out a lot of perfomance parameter -
check RAID10 and RAID5 usage !
Do you have enought disks on the array ? - With more spindles you
increase perfomance, the array can store more data in RAID10, and
increase the io.
Check the performance settings - have you got a lot of IO on the array ?
Do you have a lot of servers on the array ?

> > Glance confiuration is defualt values, I did not change anything.
>
> We did not get Oracle licence for this server yet. We want to sure this
> solution is good enuogh in performance and than buy Oracle for HP
> server.
I think, the HP must be fast.

> Is it possible that oracle without licence (unregistered databse) be
> the source of problem. I mean the trial version has some performance
> problem on HP.
Hm, i think there is no difference.

> i copied a 5 GB file from server's local HDD to SAN, it took about 6
> mins to complete. is it ok? I think it should be very faster.Do you
> think i detect the problem correctly? IS it realy IO problem or another
> thing is wrong? Please advice.
14 MB is not OK. What is about a copy from the array to the array ?
Hm, It could be a lot of problems. But check the array an the array
settings, it could be a performance issue.

Lars

Relevant Pages

  • [HPADM] Re: HPWorld in SanFrancisco...CANCELLED
    ... What do I need to do to migrate the EMC array to our new server and be ... Edward - EMC storage engineer in the audience speaks up. ...
    (HP-UX-Admin)
  • Re: storage for temporaries
    ... In an expression the array rvalue ... > is converted to a pointer to its first member. ... > storage for the structure value. ... access it after the next sequence point, ...
    (comp.lang.c)
  • Storage Tags (was: Another BIG Mainframe Bites the Dust)
    ... Didn't such tagging extend to data types, fixed vs. floating, so ... storage would have circumvented the intended protection against ... I believe such machines also had hardware array subscript ...
    (bit.listserv.ibm-main)
  • Re: Looking to build storage of about 3TB -- recommendations?
    ... > For my research I need large storage for satellite data files. ... > volatile array. ... What I am proposing is to build 2 arrays of SATA ... We envision swapping out drives in array 2 as ...
    (comp.arch.storage)
  • Re: sub-optimal code for packed boolean arrays -- bug or inherent limitation
    ... You should also be aware that you're sending the compiler conflicting messages. ... Packing the array indicates that you want the compiler to minimize storage, even at the expense of speed, while "pragma Optimize;" indicates that you want to minimize time, even at the expense of storage. ...
    (comp.lang.ada)