This discussion is archived
12 Replies Latest reply: Mar 26, 2008 5:11 AM by 630266 RSS

Slow performance with ASM!!

360194 Newbie
Currently Being Moderated
SO: AIX 5.2
Database 10gr2 10.2.0.1


* Installed database without ASM, pointing datafiles to filesystem JFS2 /u02 this works fine.

* Installed database with ASM, pointing to /dev/hdisk1, i have slow performance.


/u02 and /dev/hdisk1 are the same disk!!


Have any way to improve performance with ASM ?

Thank's
  • 1. Re: Slow performance with ASM!!
    damorgan Oracle ACE Director
    Currently Being Moderated
    The same disk at the same time?

    If not how did you remove the file system?
  • 2. Re: Slow performance with ASM!!
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    > My conclusion is that the problem is in ASM....

    Yeah... the following analogy describes you and your approach pretty well. IMO.

    The Scene:
    Empirical Scientist. White lab coat. Clipboard. In lab. Table in lab. Glass jar on table. A fly in the jar.

    The Story:
    The scientist opens the jar, and places the fly on the table. He claps his hand. The fly flies away. He notes on his clipboard, "The fly's hearing is excellent!".

    He catches the fly. He tears off the wings from the poor fly and places it on the table. Again he claps his hand. Puzzled, he claps his hands again. He notes on his clipboard, "A fly cannot hear when it does not have wings!!". He then writes, "Conclusion: The hearing organs of a fly is situated in its wings".

    The Moral:
    A conclusion based on observation only is idiotic.
  • 3. Re: Slow performance with ASM!!
    516450 Journeyer
    Currently Being Moderated
    Billy,

    Excellent analogy, I couldn't stop laughing :-)

    Thanks
    Chandra
  • 4. Re: Slow performance with ASM!!
    360194 Newbie
    Currently Being Moderated
    when install ASM, i use only /dev/hdisk1.....after....remove ASM......create a /u02 - jfs2 pointing to /dev/hdisk1 and create a tablespace in /u02.
  • 5. Re: Slow performance with ASM!!
    360194 Newbie
    Currently Being Moderated
    I not expressed correctly!

    The objective was not to compare. Only demonstrate that in my tests ASM was 10x slower.

    And i would like to know if someone had performance problems with ASM.

    Thank's

    null
  • 6. Re: Slow performance with ASM!!
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    Care to tell how you benchmarked I/O using a cooked file system versus a raw disk with ASM? Care to explain how you factored in o/s cache + db buffer cache versus ASM + db buffer cache - how you ensured you are comparing apples with apples?
  • 7. Re: Slow performance with ASM!!
    153119 Pro
    Currently Being Moderated
    He probably used the #1 instrument in 'tunning' a database: his watch!

    --
    Sybrand Bakker
    Senior Oracle DBA
  • 8. Re: Slow performance with ASM!!
    Aman.... Oracle ACE
    Currently Being Moderated
    Excellent analoggy Billy :-).For sure , I shall remember it. I am sure there will be many times it will be used by me.
    Aman....
  • 9. Re: Slow performance with ASM!!
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    > Excellent analoggy Billy :-).For sure , I shall remember it. I am sure there will be many
    times it will be used by me.

    I've first heard it back in the 90's when dealing with troubleshooting software and performance issues (a pet hobby of mine - some like taking toasters and TVs apart, I like doing that with software).

    And as you are planning to Aman, I have used it numerous times in well over a decade now. :-)

    In my view it cuts very close to the bone why using the simplistic "elapsed time" approach to many performance related issues is so fatally flawed. It also shows how important it is to know WHAT exactly what you are observing - kind of a twisted Copenhagen Interpretation where ignorance of the experiment collapses the wave function and produces totally meaningless results... ;-)
  • 10. Re: Slow performance with ASM!!
    Aman.... Oracle ACE
    Currently Being Moderated
    Billy,
    I must say that its really a straight hammer hit over the head when some one is talking about wall clock time approach for tuning.I really couldnt stop laughing after reading it.
    Surely I shall use it whenever it will be required and I am sure that it will surely raise an eyebrow :-).
    Thanks again for it.
    Aman....
  • 11. Re: Slow performance with ASM!!
    630306 Newbie
    Currently Being Moderated
    But what happened to other replies of this thread about bug 5893614?
  • 12. Re: Slow performance with ASM!!
    630266 Newbie
    Currently Being Moderated
    Hi,

    How you concluded that the performance with ASM is bad. (i.e what statistics... whether you are seeing high I/O or something else!!!).

    As per bug 5893614 Full table scans can be very slow on ASM compared to file system. If you are seeing waits on 'db file scattered read" then it may be the case.

    It is better to collect AWR report for the time when database is performing slow.


    Thanks
    Saurabh Sood