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

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

Date: 17 Feb 2005 03:13:54 -0800

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.
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.

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.

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.
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.
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.

Alireza

Relevant Pages

  • Re: Anyone using ZFS with SAN storage?
    ... the situation where storage comes from a virtual disk on a SAN, ... any drawbacks to using ZFS in this manner? ...
    (comp.unix.solaris)
  • 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: Network Storage Help
    ... i didnt say to buy an expensiv NAS box... ... NAS boxes are traditionally crap at block storage, but SAN arrays can ... And Oracle *recommends* using NFS with Oracle RAC, ...
    (comp.arch.storage)
  • Re: New Disk storage - Change drive letters
    ... >node cluster) and this has been connected to the Exchange cluster nodes and ... >is accessible as shared disk storage. ... Is this an existing cluster that has got a new SAN connected and new ...
    (microsoft.public.exchange.admin)
  • New Disk storage - Change drive letters
    ... I'm planning on adding a new SAN to our Exchange system (Active/Passive 2 ... is accessible as shared disk storage. ... Option 2) Manually copy the files onto the new disk storage ...
    (microsoft.public.exchange.admin)