Same SQL Plan, Different Performance

    Session Number: 1200
    Track: 5-Data Warehousing and SQL
    Session Type: Best Practices, Tips & Tricks
    Primary Presenter: Mauro Pagano [Accenture Enkitec Group]
    Time: Jan 27, 2016 (03:25 PM - 04:15 PM)

    Session level: Intermediate
    Keywords: None

    Abstract (250 words or less): 

    Sometimes even when you do all your homework and make sure a SQL statement has exactly the same plan, you still end up seeing different performance across environments. What would possibly cause it? This session will focus on the most common scenarios that make an execution plan (or a step of it) slow down your SQL  statement across different environments. We’ll use real-life examples to learn how to identify the symptoms of such factors using the standard diagnostics (mostly 10046 trace / v$ views), how such factors affect the performance of your SQL statement, and how to address them.

     



    Independent Oracle Users Group
    330 N. Wabash Ave., Suite 2000, Chicago, IL 60611
    phone: 312-245-1579 | email: ioug@ioug.org

    Copyright © 1993-2017 by the Independent Oracle Users Group
    Terms of Use | Privacy Policy