On Jun 21, 6:43 am, "F. Michael Orr" <michael_or...@yahoo.com> wrote:
> On Thu, 21 Jun 2007 15:03:52 +0200, Sierp wrote:
> > Hello all,
>
> > we have bought p570 machine with AIX 5.3 system. It's already configured
> > etc, but.. we have very low database performance with this
> > configuration. We are using EMC Symmetrix (without powerpath!), Oracle
> > 10 Database with ASM.
>
> > We have tried with rhdisk devices (raw devices) and LVM volumes for ASM
> > subsystem - both without success... We have tried to tune AIX (ie using
> > this document
> >http://www-03.ibm.com/support/techdo...Index/WP100708
> > also without success. The database is very slow.
>
> > Does anyone is using ASM for Oracle with AIX?
>
> > regards,
>
> > Sierp
>
> I'm not a DBA, but ours have been trying to set this up on a slightly
> different configuration (same servers, different storage array) in order
> to support RAC, and have been having a lot of problems with it.
> According to them, even Oracle doesn't run ASM internally, so it's
> something of a stepchild. They have decided to go a different route. So
> we have not gotten to the point of even being able to try performance,
> and have had issues.- Hide quoted text -
>
> - Show quoted text -
I run this setup with powerpath -- AND get the latest oracle
patches-- it is incredibly buggy-- and have aix53-04-CSP at least.
Performance is OK but how do you keep track of the disks? it is very
hard to tell with ASM and LVM ( we also have VxVM/CFS so its even
worse) -- lspv won't be right ; pvid's are meaningless ; I use EMC
lun IDs to track disks across nodes.
DBA's don't like ASM either because it has them interacting with the
hardware more than they want to. We are looking at replacing ASM
with veritas CFS for concurrent access filesystems; juts so we can
mange the disks better.
things like adding and removing disks become a noightmare -- scsi
reserve bits get reset and the db won't come up on one node-- hard to
diagnose that until you've done it.
ASM needs a much better admin tool before it will be usable in the
world.