Optimizer Master Class

The workshop begins with an in-depth look at statistics and statistics maintenance, a challenge all DBAs must face in order to prevent sub-optimal execution plan. This presentation includes information on the features introduced in Oracle Database 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.


The workshop continues with a detailed explanation on how to interpret an execution plan. Each aspects of an execution plan is examined, from cardinality estimates to parallel execution and you will learn what information you should be gleaming from the plan and how it affects the execution.


After lunch the workshop focuses on the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method and more. With clear how-to examples you will learn how to identify and quickly resolve these issues and develop a methodology to prevent them in the future.

Topics:

  • Introduction to the Oracle Optimizer and in-depth discussion on statistics
  • Explaining the EXPLAIN PLAN
  • Detailed look at what can cause an execution plan to go wrong
  • Guide to tuning SQL statements

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Tom worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Tom spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Tom is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Tom is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

Time Friday, 7th November 2014
07:00 to 08:30 Registration
  Room A
 Database Track
Room B
 Database Track
 Room C
 EBS Track
Room D
 EBS Track
Room E
MW/BI Track
Room F
SIG Track
Room G
PSFT Track
08:00 to 08:15 Welcome - PS Janakiram 
User Groups: Update
08:15 to 08:45 Keynote
Oracle's Technology Innovations - On Premise & On the Cloud
Mitesh Agarwal, Country Head –Sales Consulting, Oracle India
08:45 to 09:05 Meet your user group leaders
09:05  to 09:15 Interchange
09:15 to 10:05 Optimizer Master Class
Full day Seminar
 Tom Kyte
India OAUG Update, Launch of PSFT SIG
Chitti Babu

India OAUG Update, Launch of PSFT SIG
Room C & D
  India OAUG Update, Launch of PSFT SIG
Room C & D
10:05  to 10:35 Coffee, Networking & Exhibition Time
10:35 to 11:25 Optimizer Master Class
Full day Seminar
Tom Kyte
201533
Secondary Ledgers : Unleashing Its Power
Anshu Anand
201573
Asset Intensive Industries - An Oracle E-Business Suite approach for efficient ALM
Arunkumar Kaliappan 
201421
Customizations of Enterprise Applications using Meta Data Services in Oracle ADF
Rohan Walia
211001
PeopleSoft Technology Update and Roadmap
Pramod Agrawal
11:25  to 11:35 Interchange
11:35 to 12:00 Optimizer Master Class
Full day Seminar
Tom Kyte
201436
Best Practices in E-Business Suite Performance Tuning
Kandasamy Nainamalai
201489
Demystifying Demantra Integration with Value Chain Planning
Srikanta Nanjundaswamy
201643
Business Intelligence in the Cloud
UmaMaheshwari Madaka 
211004
PeopleSoft In-Memory Project Discovery: Gain a Competitive Advantage
Prabhakaran Marimuthu
12:05 to 12:30 201531
Integration of Oracle Forms with ADF
Richard Dalvi
12:30 to 01:30 Lunch, Networking & Exhibition-ime
01:30 to 02:20 Optimizer Master Class
Full day Seminar
    Tom Kyte
201532
Lessons learned in R12 upgrade and the best practices to minimize the downtime
Ramam Kallakuri 
201558
Enabling real-time decision making with E-Business Suite In-Memory Applications
Muralidhar Reddy
201466
Analytics for leadership - Maximise your Investment with OBIEE
Suchitra Gummadi
RAC - Special Interest Group (SIG)
Ajith Narayanan
211003
PeopleTools Fluid Interface - Build responsive applications for mobility
Jeevan John
02:20  to 02:30 Interchange
02:30 to 03:20 Optimizer Master Class
Full day Seminar
Tom Kyte
201646
Changing the Chart Of Accounts using tools
Satish Tiwari
211015
Delivering Value via Accelerating ERP Projects
Rajasekhar Ravichandran
211227
Oracle Java Cloud Service
Ravi Pinto
ES - Special Interest Group (SIG)
Satyendra Kumar
211002
PeopleTools Pivot Grids - Analytics for PeopleSoft applications
Rahul Mahashabde
Balaji Pattabhiraman
03:20 to 03:50 Coffee, Networking & Exhibition-Time
03:50 to 04:40 Optimizer Master Class
Full day Seminar
Tom Kyte
201510
LCM Integration with Discrete and Process Manufacturing
Kishor Genikala
201527
Using Enterprise Asset Management (EAM) Preventive Maintenance
Venkatesh Hemmige
201501
Securing Mobile clients using OAuth Service
Vandana Rajamani
EM - Special Interest Group (SIG)
Gagan Chawla
211006
Update on PeopleSoft HCM and Fusion co-existence
Murali Vemaraju
04:40 to 04:50 Interchange
04:50 to 05:40 Optimizer Master Class
Full day Seminar
Tom Kyte
211021
Oracle E-Business Suite Technology - Latest Features
Veshaal Singh
201513
Inventory Reconcilaition for OPM Organizations - An approach and steps
Subramanian Sankaran
201471
OBIA Integration with ODI 11.1.1.7 - The future
Kanchan Kumar
User Group Round Table PSFT Round Table
Please note allocation of rooms, day and session times are subject to change

Quick Links

About Us

AIOUG is a non profit organization, provides Oracle technology and database professionals the opportunity to enhance their productivity and influence the quality, usability, and support of Oracle technology. For more details www.aioug.org

Stay Connected on:


Contacts

For general information about the event/conference, including registration, please contact us at:
  This email address is being protected from spambots. You need JavaScript enabled to view it.