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
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.