1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Performance tunning in Oracle Apps

Discussion in 'System Administration & Application DBA' started by vinay056, Aug 24, 2011.

  1. vinay056

    vinay056 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Performance Tunning
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Where is the rest of the methodology? Where are the new features from 11g like setting the optimizer_dynamic_sampling parameter? Where is the discussion on the differences that can be displayed between explain plan and autotrace? Where is the discussion on how to combine the plan and the per-query statistics to determine if a plan is good or bad? Where is the discussion on plan stability, profiles, baselines and outlines? Where is the discussion on how system statistics affect query plans? Where is the discussion on how to tune statements you cannot change? The CHOOSE optimizer_mode value has been deprecated; why wasn't that mentioned? How does one ensure that the current statistics accurately reflect the data? Prove why all_rows favors full table scans because I don't experience that behaviour in my systems. Oracle can 'ignore' a hint if the statistics provide a better execution plan; why wasn't that discussed? How does all of this apply to Oracle applications?

    There is much missing from your presentation.