Performance degradation after upgrading from 10gR2 to 11gR2 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Performance degradation after upgrading from 10gR2 to 11gR2

  1. #11
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    No hard feelings

  2. #12
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool

    Quote Originally Posted by gandolf989 View Post
    Is that like pressing the easy button? It looks like your parameter does not help if you already use ASM.
    Only works with "cooked" disk (not ASM).
    The main problem was occurring due to Linux disk "cache" and the parameter allowed Oracle to bypass the OS file manager.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #13
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi guys,

    I wanted to update that after a long session with Oracle Support via SR , they decided that this behavior is a bug in 11.2.0.3 and they are developing now a fix.
    Bug 17397506 : SORT MERGE INCORRECTLY CHOSEN OVER HJ IN 11.2.0.3
    The workaround that I've got from them:
    Setting the parameter _optimizer_filter_pushdown to FALSE.
    For testing this parameter , I've applied it in session level (by a trigger) on a group of customers.
    Most of the screwed reports were improved but there were several reports that their good explain plan was screwed because of this parameter.We tread them with hints.

    Regards,
    Nir

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width