Calendar

Month: Year:
« Prev February 2015 Next »
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1
2
3
* ODTUG Free WebinarODTUG Free Webinar

Time: 10:00 am

Oracle BI Mobile Application Designer Is Your New Best Friend, Kevin McGinley, Red Pill Analytics With deployment of BI to mobile devices on the rise, more and more Oracle BI customers are turning toward the simplicity of delivering browser-based applications using Oracle BI Mobile Application Designer. With the latest release, companies are also realizing they can leverage Mobile Application Designer in exciting new ways, even for desktop users. This session will demonstrate and discuss how you get the most value out of Oracle BI Mobile Application Designer for mobile users, power users, and even casual users.

* IOUG Free WebinarsIOUG Free Webinars

Time: 11:00 am

IOUG Member Town Hall and "You've Got It---Flaunt It: Oracle Enterprise Manager Extensibility” Tue, Feb 3, 2015 11:00 AM - 12:00 PM MST Join IOUG for our 2015 Member Town Hall to learn more on how you can maximize your membership this year and make the most of your training dollars. In the first part of this webinar we will be reviewing 2014 IOUG educational initiatives and debuting 2015 training opportunities. Learn more about how you can become active in IOUG and connect with the 25,000+ users in our community. The second part of the webinar will feature a preview of a COLLABORATE 15 educational session from SELECT Journal Executive Editor, Ray Smith entitled "You've Got It---Flaunt It: Oracle Enterprise Manager Extensibility." Many shops have adopted Oracle Enterprise Manager Cloud Control (OEM) for real-time monitoring and maintenance. In this session you'll be introduced to the powerful reporting features built into OEM. Public reports expand the value of OEM to your enterprise and improve your personal productivity. Speakers: John Matelski President, IOUG Board of Directors Ray Smith Executive Editor, SELECT Journal

4
5
6
7
8
9
* Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training

Time: 12:00 am

Optimizing Oracle SQL, Intensive On location in Reston, VA Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

10
* Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training

Time: 12:00 am

Optimizing Oracle SQL, Intensive On location in Reston, VA Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

11
* Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training

Time: 12:00 am

Optimizing Oracle SQL, Intensive On location in Reston, VA Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

12
* Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training

Time: 12:00 am

Optimizing Oracle SQL, Intensive On location in Reston, VA Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

13
* Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training

Time: 12:00 am

Optimizing Oracle SQL, Intensive On location in Reston, VA Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

14
15
16
17
* RMOUG Training Days 2015RMOUG Training Days 2015

Annual conference of the Rocky Mountain Oracle Users Group on Tue-Thu 17-19 February 2015 at the Colorado Convention Center in Denver CO. This is one of the biggest and most highly regarded Oracle users conferences in the world.

18
* RMOUG Training Days 2015RMOUG Training Days 2015

Annual conference of the Rocky Mountain Oracle Users Group on Tue-Thu 17-19 February 2015 at the Colorado Convention Center in Denver CO. This is one of the biggest and most highly regarded Oracle users conferences in the world.

* Hotsos Online TrainingHotsos Online Training

Time: 8:30 am

Understanding Statistics in Oracle Objective: During this class we’ll examine, in detail, what the statistics are on your Oracle system. You will better understand both the schema (tables and indexes) as well as system statistics. With this understanding you will know when statistics are likely the cause of performance issues with your Oracle system. Target Audience: The course is designed for anyone who writes SQL in Oracle. With a better understanding of how and what the statistics are on your system you will be able to configure your Oracle system to have the best statistics available to the optimizer to get the best plans from the optimizer. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer.

* IOUG Free WebinarsIOUG Free Webinars

Time: 11:00 am

Everything You Wanted to Know about Multitenant Wednesday, February 18 2015 12:00 p.m. - 1:00 p.m. CDT You’ve heard about the multitenant feature of Oracle Database 12c, but why does it matter to your company? Lots of reasons. Join Oracle’s foremost Multitenant expert Patrick Wheeler, and Oracle guru Arup Nanda as they dig into the multitenant architecture, how it simplifies consolidation and enables DBaaS, how it can have a significant on the cost of delivering database services, and how your regular activities--backup, recovery, data guard, security, etc--will change after you change over to multitenant. Featured Speakers: - Arup Nanda, Principal Database Architect at Starwood Hotels & Resorts Worldwide, Inc.; - Patrick Wheeler, Senior Director, Product Management, Oracle Corporation

19
* RMOUG Training Days 2015RMOUG Training Days 2015

Annual conference of the Rocky Mountain Oracle Users Group on Tue-Thu 17-19 February 2015 at the Colorado Convention Center in Denver CO. This is one of the biggest and most highly regarded Oracle users conferences in the world.

* Hotsos Online TrainingHotsos Online Training

Time: 8:30 am

Reading Execution Plans Objective: During this class we’ll examine, in detail, how to read an execution plan in Oracle. The focus is to understand how the steps of the plan interact and being able to quickly understand what the plan is doing, and to know where to look in a plan for problem points. Target Audience: The course is designed for anyone who writes SQL in Oracle. If you have ever looked at an execution plan (or explain plan) and wondered what was all that stuff, this is the class for you. If you have a general idea of what it is, but want to know more, this is the class is for you. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach the student to read execution plans. The course will also enable them to read explain plans; as the two look the same. Students will be able to read and understand the individual steps of a plan and the interaction of these steps in a plan.

20
21
22
23
* Hotsos Online TrainingHotsos Online Training

Optimizing Oracle SQL, Intensive Online webinar Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

24
* Hotsos Online TrainingHotsos Online Training

Optimizing Oracle SQL, Intensive Online webinar Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

25
* Hotsos Online TrainingHotsos Online Training

Optimizing Oracle SQL, Intensive Online webinar Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

26
* Hotsos Online TrainingHotsos Online Training

Optimizing Oracle SQL, Intensive Online webinar Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

27
* Hotsos Online TrainingHotsos Online Training

Optimizing Oracle SQL, Intensive Online webinar Objective: This class is a 5-day intensive combination of material that would typically be covered in 7 days. Focus is directed towards the optimizer and understanding how it behaves when developing query execution plans. The importance of optimizing SQL at the resource usage level is learned and the Hotsos SQL Test Harness and Tools Pack scripts are used to facilitate the comparison of multiple approaches to writing SQL statements to discover the "performance optimal" choice among several approaches. Different approaches to writing high performance SQL are demonstrated as well as review of database design elements that can affect performance. Target Audience: The course is designed for application developers and database administrators who want to respond faster and more permanently to Oracle system performance problems that are known to be caused by inefficient application SQL code. Whether you are wanting to learn how to write new code that performs optimally from the start or are looking to update and maintain previously written code, this course teaches you the skills you need. We take you 'under the covers' to see how and why your SQL performs as it does and lead you to understand how to most effectively provide the Oracle optimizer with the information it needs to produce optimal execution plans. Simply put, if you write SQL, this class is for you! The course is most effective for students who will be motivated to solve real Oracle system performance problems immediately upon returning to work after the course. Prerequisites: Students are expected to have a working knowledge of Oracle SQL through experience either as a database administrator or application developer. Synopsis: This course is intended to teach students a repeatable and reliable method for optimizing SQL and to assimilate the new habit of testing optimization hypotheses rapidly during the performance improvement process. Instead of relying on “rules of thumb” and hit-and-miss guessing, this course helps the student understand the inner workings of the Oracle optimizer and how SQL execution paths are determined. Particular emphasis is placed on discovering how to capture, read, and understand execution plans and how to use 10053 trace data to follow the optimizer's plan selection. The student's attention is focused not upon rote learning and superficial understanding of Oracle rules of thumb, but upon a thorough understanding how the Oracle database works. The course is not just about learning how to write SQL. The course is about arming the student with the skills to be able to scientifically determine the efficiency of any SQL statement. While the course does offer alternative ways to write SQL in many cases, the primary objective is to equip the student to determine whether a statement is optimal and to achieve a deeper understanding of the cost-based optimizer. This course presents problem-solving strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for optimizing SQL in ever more challenging situations.

28
Category Key
 Board Meeting
 Corporate Sponsor
 Newsletter Deadline
 Oracle Corporation
 Other Users Group
 Presentation/Webinar
 QEW
 Training Days