Come Learn and Play QEW – August 8th at Elitch Gardens

Quarterly Educational Workshop

Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204

Come join us at Elitch Gardens on Friday, August 08, 2014, for a morning of technical seminars, and an afternoon of fun, courtesy of RMOUG and additional sponsors. Bring your colleagues, bring your family, bring your desire to learn, and reboot.

Agenda:
8:30 am – 9:00 Registration and Continental Breakfast

9:00 am – 9:15 am RMOUG Business and Welcome

9:15-10:15 Performance Innovation with Database In-Memory
Enterprises are always looking for ways to make business decisions more quickly.  Oracle Database In-Memory is a solution for accelerating database queries and enabling businesses to make better and faster decisions.  Oracle’s unique approach leverages a new in-memory column store format to speed up analytic, data warehousing, and reporting workloads.  Existing applications automatically and transparently take advantage of in-memory processing without requiring any changes or without losing any existing Oracle database capabilities.  With Oracle Database In-Memory, everything just works faster.  Learn more about the Oracle Database In-Memory option and how you can make better and faster database-driven business decisions.

Click here to access and download the presentation.

10:30-11:30 What’s New in Database Consolidation
Oracle Database 12c introduces a new multitenant architecture that offers greater utilization and scalability of server resources through simplified database consolidation onto private clouds. It fully complements proven database technologies such as Real Application Clusters, and effectively enables customers to manage many databases as one, without the need to change existing applications.  In addition, Oracle Multitenant offers very fast provisioning and cloning of databases, rapid database patching and upgrades, and secure isolation of data. During this session, we’ll examine Oracle Multitenant in some detail and explain how this new architecture works.

Click here to access and download the presentation.

11:45 Lunch (Remember to invite your friends and family!)

Registration Required for all Attendees!

New Fusion Middleware Special Interest Group!

 
 

RMOUG is proud to announce the formation of a new Fusion Middleware Users Group!

The purpose of the Fusion Middleware Users Group is to share innovative ideas and thought leadership in utilization of Oracle Fusion Middleware to deliver business value across the enterprise. To achieve this, we will focus on both the integration and expansion across the corporations that these products can provide in addition to single product advancement.  Please click here to visit the FMW Special Interest Group Page and complete a simple poll  that will help us understand your needs/wants and when we should hold meetings.

IOUG Master Class Series – Database Consolidation

IOUG Master Class Series Coming to Broomfield
Database Consolidation

Tuesday, June 3, 2014
9am- 3:30pm MT
Oracle Broomfield Campus
500 Eldorado Blvd
Broomfield, CO 80021
Complimentary Registration and Lunch

Growing data is affecting all DBAs and Oracle professionals. In this one day Master Class with IOUG and Oracle learn how database consolidation can enhance your performance plus save your company time and money. Through real world examples and live demos from Oracle experts you will return to work with a road map to how you can begin consolidating your database.

Featuring:
Tim Mooney, Director of Product Marketing, Oracle Exadata Database Machine, Oracle’s first and most popular Engineered System

Erik Benner, Solutions Architect, BIAS Corporation, A Platinum Oracle partner who has implemented dozens of database consolidation projects

During this one-day interactive training event Oracle experts, Eric Benner and Tim Mooney, will:
• Identify how to plan a consolidation project using OEM12c
• Explain how to migrate databases to the consolidated platform
• Leverage best practices to explain how to avoid common challenges
• Explore how you manage the systems after consolidation
• Give you the opportunity to have your database consolidation questions answered by Oracle experts

This event is FREE to attend and lunch will be provided. Don’t miss this opportunity to stay on top of
your career and latest industry trends and techniques without having to travel far from home.

« Previous Page — Next Page »

• Training Days 2015

  

• Volunteer for RMOUG!

  Volunteer Sign-up Form,
  Including Training Days
  

• RMOUG Membership

  Self-service
  Membership Application
  

• Connect with RMOUG

  
  

• Contact RMOUG

  Rocky Mountain Oracle
  Users Group (RMOUG)
  P.O. Box 621942
  Littleton, CO 80162
  admin@rmoug.org
  (303) 929-6266
  

• Full Page Calendar

  Click for Full Page Calendar

• Upcoming RMOUG Events

  • January 26, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in San Francisco, CA 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. all day
    • Oracle BIWA Summit 2015Oracle BIWA Summit 2015
      
      Oracle Conference Center at Oracle HQ Campus, Redwood Shores, CA 94065 BIWA summits are organized and managed by Oracle BI, DW and Analytics user community. This year, BIWA Summit includes the 11th annual Oracle Spatial Summit. This event attracts the top Oracle BI, Data Warehouse, Advanced Analytics, Big Data and Spatial and Graph experts. The 3-day event includes: - Keynotes by Industry Experts - Educational Sessions by Practioners and Direct from Developers - Hands-on-Labs - Networking Events Agenda includes... - Advanced Analytics - BI and Visualization - Big Data - Cloud Computing - Data Warehousing and ETL - Engineered Systems - Graph Database and Analytics - Internet of Things all day
  • January 27, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in San Francisco, CA 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. all day
    • Oracle BIWA Summit 2015Oracle BIWA Summit 2015
      
      Oracle Conference Center at Oracle HQ Campus, Redwood Shores, CA 94065 BIWA summits are organized and managed by Oracle BI, DW and Analytics user community. This year, BIWA Summit includes the 11th annual Oracle Spatial Summit. This event attracts the top Oracle BI, Data Warehouse, Advanced Analytics, Big Data and Spatial and Graph experts. The 3-day event includes: - Keynotes by Industry Experts - Educational Sessions by Practioners and Direct from Developers - Hands-on-Labs - Networking Events Agenda includes... - Advanced Analytics - BI and Visualization - Big Data - Cloud Computing - Data Warehousing and ETL - Engineered Systems - Graph Database and Analytics - Internet of Things all day
    • NoCOUG Winter ConferenceNoCOUG Winter Conference
      
      Time: 7:00 am
      
      Tuesday, January 27, 8 AM–5 PM Oracle Conference Center 350 Oracle Parkway Redwood City, CA 94065 at 7:00 am
    • IOUG Free WebinarsIOUG Free Webinars
      
      Time: 9:00 am
      
      Reinventing Database Protection and Data Loss Recovery Tue, Jan 27, 2015 9:00 AM - 10:00 AM MST Most existing data protection solutions fail to meet the demands of critical databases because they treat databases as simple files to copy rather than transactional systems with data integrity, performance and availability requirements. These existing solutions may lose business data, impact end users and cause unnecessary business complexity. Join Oracle’s Recovery Appliance Principal Product Manager, Tim Chien and Principal Product Marketing Director, Steve Rudinsky to learn more about a groundbreaking data protection solution that’s completely integrated with Oracle Database. This webcast will dive into Oracle’s Zero Data Loss Recovery Appliance that tightly integrates advanced data protection technologies with the Oracle Database to tackle data challenges. You will leave this session knowing how to better prepare for Data Loss Recovery including: • Eliminating data loss • Minimizing production impacts • Ensuring database level recoverability • Providing cloud-scale protection for hundreds to thousands of databases During this webinar, you will learn how: Oracle’s Recovery Appliance fits into the database protection marketplace; how Oracle Database customers are using this new appliance; and how you can participate in a hands-on workshop to experience the Recovery Appliance for yourself. Featured Speaker: Tim Chien, Principal Product Manager and Steve Rudinsky, Principal Product Marketing Director, Oracle at 9:00 am
    • ODTUG Free WebinarODTUG Free Webinar
      
      Time: 10:00 am
      
      Calc Manager: Pushing the Envelope to Drive ROI, Ron Moore, TopDown Consulting Calc Manager inherited many of the must-do Planning calculation tasks from Business Rules, but there are also some groundbreaking new features that can give you some quick wins and help you push the analytical envelope. Join Ron Moore, solutions architect for TopDown Consulting, to learn how to take advantage of Calc Manager’s new features to speed up routine processes and add new analytical power. Webcast topics provide tips, tricks, and best practices, including: • Automating dynamic backup and restore on regions of the database • “Packaging” powerful analytics, such as rolling calculations, projections, and allocations • Strategies for rationalizing many repetitive calc scripts • Using custom templates • Using new debugging and optimization features At the end of the webcast, you will have some new tricks you can use right away as well as some new ideas to increase analytical power and ROI. at 10:00 am
  • January 28, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in San Francisco, CA 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. all day
    • IOUG Free WebinarsIOUG Free Webinars
      
      Time: 11:00 am
      
      Oracle GoldenGate 12c Use Cases, Oracle GoldenGate 12c Uni-Directional Configuration and IOUG Data Integration SIG Wed, Jan 28, 2015 11:00 AM - 12:00 PM MST This session will introduce the different Oracle GoldenGate 12c use cases to the community and how Oracle GoldenGate 12c can be used to implement a uni-directional architecture. By highlighting these use cases, this session will provide the basics for understanding Oracle GoldenGate 12c and how to configure each of the components in the architecture within an Oracle-to-Oracle environment. Additionally, this session will establish the IOUG Data Integration Special Interest Group (SIG) within the IOUG community, outline the direction for the SIG and establish a defined architecture for the SIG. Takeaways: • Clearly define the supported architectures/use cases with Oracle GoldenGate 12c • Architecture of Oracle GoldenGate 12c in a Uni-Directional configuration • Components for establishing uni-directional replication • Clearly define the IOUG Data Integration Special Interest Group Featured Speaker: Bobby Curtis and Joseph Debuzna, Oracle Storage at 11:00 am
  • January 29, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in San Francisco, CA 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. all day
    • IOUG Free WebinarsIOUG Free Webinars
      
      Time: 11:00 am
      
      Stop the Madness! Thu, Jan 29, 2015 11:00 AM - 12:00 PM MST Want to learn how to make Oracle and PeopleSoft application changes fast, reliably and compliant? Due to time constraints and overloaded schedules, Oracle Application business analysts and super users sometimes take short-cuts and make unauthorized changes directly in their production environment. Why? The changes are usually in response to an application problem that needs a fix ASAP. So what? Well, the changes may fix the issue with the application but it may create other issues since the formal change management process wasn’t followed, increasing risk of audit and compliance issues as well as increasing the risk of future application outages. During this 45-minute webinar, you will learn how to: - Generate detailed change reports & comprehensive audit trails for Oracle E-Business Suite & PeopleSoft Applications - Automate migration of application setup objects between multiple instances and across multiple environments -reducing migration time by 75% or more on your Oracle R12 projects - Perform impact analysis to show how patches will affect objects - Schedule automated deployments and recovery capabilities Featured Speaker: : Fernando Volonte and Dennis Nelson, Dell at 11:00 am
  • January 30, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in San Francisco, CA 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. all day
  • February 3, 2015
    • 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. at 10:00 am
    • 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 at 11:00 am
  • February 9, 2015
    • 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. at 12:00 am
  • February 10, 2015
    • 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. at 12:00 am
  • February 11, 2015
    • 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. at 12:00 am
  • February 12, 2015
    • 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. at 12:00 am
  • February 13, 2015
    • 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. at 12:00 am
  • February 17, 2015
    • 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. all day
  • February 18, 2015
    • 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. all day
    • 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. at 8:30 am
    • 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 at 11:00 am
  • February 19, 2015
    • 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. all day
    • 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. at 8:30 am
  • February 23, 2015
    • 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. all day
  • February 24, 2015
    • 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. all day
  • February 25, 2015
    • 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. all day
  • February 26, 2015
    • 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. all day
  • February 27, 2015
    • 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. all day
  • March 1, 2015
    • Hotsos Symposium 2015Hotsos Symposium 2015
      
      Time: 12:00 am
      
      Hotsos Symposium is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity. Hotsos Symposium reaches for a new technical high with presentations focused on techniques, experimental results, and field-tested scripts that attendees can take home and apply to real-world tasks. The speakers routinely offer an excellent balance between database principles and problem-solving techniques. The speakers also show you how to determine the difference between reliable information and bad advice around Oracle performance optimization. at 12:00 am
  • March 2, 2015
    • Hotsos Symposium 2015Hotsos Symposium 2015
      
      Time: 12:00 am
      
      Hotsos Symposium is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity. Hotsos Symposium reaches for a new technical high with presentations focused on techniques, experimental results, and field-tested scripts that attendees can take home and apply to real-world tasks. The speakers routinely offer an excellent balance between database principles and problem-solving techniques. The speakers also show you how to determine the difference between reliable information and bad advice around Oracle performance optimization. at 12:00 am
  • March 3, 2015
    • Hotsos Symposium 2015Hotsos Symposium 2015
      
      Time: 12:00 am
      
      Hotsos Symposium is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity. Hotsos Symposium reaches for a new technical high with presentations focused on techniques, experimental results, and field-tested scripts that attendees can take home and apply to real-world tasks. The speakers routinely offer an excellent balance between database principles and problem-solving techniques. The speakers also show you how to determine the difference between reliable information and bad advice around Oracle performance optimization. at 12:00 am
  • March 4, 2015
    • Hotsos Symposium 2015Hotsos Symposium 2015
      
      Time: 12:00 am
      
      Hotsos Symposium is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity. Hotsos Symposium reaches for a new technical high with presentations focused on techniques, experimental results, and field-tested scripts that attendees can take home and apply to real-world tasks. The speakers routinely offer an excellent balance between database principles and problem-solving techniques. The speakers also show you how to determine the difference between reliable information and bad advice around Oracle performance optimization. at 12:00 am
  • March 5, 2015
    • Hotsos Symposium 2015Hotsos Symposium 2015
      
      Time: 12:00 am
      
      Hotsos Symposium is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity. Hotsos Symposium reaches for a new technical high with presentations focused on techniques, experimental results, and field-tested scripts that attendees can take home and apply to real-world tasks. The speakers routinely offer an excellent balance between database principles and problem-solving techniques. The speakers also show you how to determine the difference between reliable information and bad advice around Oracle performance optimization. at 12:00 am
  • March 10, 2015
    • ODTUG Free WebinarODTUG Free Webinar
      
      Time: 1:00 pm
      
      Unstructured Data: Database or File System? The Debate Continues Marcelle Kratochvil, Piction Fifteen years after the release of Oracle8i and the capability to store large volumes of unstructured data in the database was introduced, the debate still continues today about the best location for storing it. Should it be the file system or the database? This seminar will address both issues and offer a future direction for all sites to follow regarding this controversial topic. at 1:00 pm
  • March 11, 2015
    • UTOUG Training Days 2015UTOUG Training Days 2015
      
      Time: 12:00 am
      
      The Utah Oracle Users group has two days with almost 40 presentations on the latest and greatest tips, tricks and helpful info in the following tracks: - Application Express - Applications - Business Intelligence - DBA - Development - MySQL - Other Don't let this opportunity pass you by! Register today! at 12:00 am
  • March 12, 2015
    • OUGN Vårseminar 2015OUGN Vårseminar 2015
      
      Oracle Users Group Norway is holding its annual spring "Vårseminar" on Thursday-Saturday 12-14 March 2015 on the cruise ship "Color Fantasy", departing Oslo on Thursday, turning around in Kiel Germany on Friday, arriving back into Oslo on Saturday. all day
    • UTOUG Training Days 2015UTOUG Training Days 2015
      
      Time: 12:00 am
      
      The Utah Oracle Users group has two days with almost 40 presentations on the latest and greatest tips, tricks and helpful info in the following tracks: - Application Express - Applications - Business Intelligence - DBA - Development - MySQL - Other Don't let this opportunity pass you by! Register today! at 12:00 am
  • March 13, 2015
    • OUGN Vårseminar 2015OUGN Vårseminar 2015
      
      Oracle Users Group Norway is holding its annual spring "Vårseminar" on Thursday-Saturday 12-14 March 2015 on the cruise ship "Color Fantasy", departing Oslo on Thursday, turning around in Kiel Germany on Friday, arriving back into Oslo on Saturday. all day
  • March 14, 2015
    • OUGN Vårseminar 2015OUGN Vårseminar 2015
      
      Oracle Users Group Norway is holding its annual spring "Vårseminar" on Thursday-Saturday 12-14 March 2015 on the cruise ship "Color Fantasy", departing Oslo on Thursday, turning around in Kiel Germany on Friday, arriving back into Oslo on Saturday. all day
  • March 19, 2015
    • C-Level conferenceC-Level conference
      
      Welcome to C-Level @ A Mile High! Colorado Technology Association (CTA) C-Level @ A Mile High(tm) connects solution providers with "C" Level IT executive "celebrities" to create a one of a kind marketplace. This always sold-out event is the largest B2B technology networking event in Colorado and CTA's most important fundraiser. Each year 80+ celebrities volunteer their time and provide custom experience packages such as a golf outing or dinner in a downtown restaurant. Several silent auction items will be available including exotic trip packages, golf, spa getaways and sports/movie memorabilia and more. Winners of the auctioned celebrities enjoy these opportunities to build and solidify relationships. all day
    • NYOUG Spring General MeetingNYOUG Spring General Meeting
      
      Spring 2015 general meeting of the New York Oracle Users Group in location TBD in downtown NYC, NY. all day
  • March 23, 2015
    • 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. all day
  • March 24, 2015
    • 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. all day
  • March 25, 2015
    • 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. all day
    • Hotsos Online TrainingHotsos Online Training
      
      Time: 9: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. at 9:30 am
  • March 26, 2015
    • Hotsos Online TrainingHotsos Online Training
      
      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. all day
    • 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. all day
  • March 27, 2015
    • 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. all day
  • March 30, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in Dallas TX 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. all day
  • March 31, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in Dallas TX 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. all day
  • April 1, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in Dallas TX 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. all day
  • April 2, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in Dallas TX 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. all day
  • April 3, 2015
    • Hotsos Out-Of-Town TrainingHotsos Out-Of-Town Training
      
      Optimizing Oracle SQL, Intensive On location in Dallas TX 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. all day
  • April 12, 2015
    • Collaborate 2015Collaborate 2015
      
      The annual Oracle users conference COLLABORATE 15 - IOUG Forum will take place in Las Vegas from April 12-16, 2015 at the Mandalay Bay Resort & Casino. This is a once-a-year opportunity to connect with the members of not one but three Oracle users groups (IOUG, OAUG and Quest) as well as with the top names and faces in the Oracle community. For more than 20 years, IOUG has delivered a unique event with leading-edge content for Oracle technology users. We fully anticipate that the COLLABORATE 15 - IOUG Forum will meet and exceed the high watermark set by COLLABORATE 14, which had over 5,500 attendees, 1,250 presentations and a full week of great events and networking opportunities. We look forward to bringing together our engaged, expert user community in April 2015! all day
  • April 13, 2015
    • Collaborate 2015Collaborate 2015
      
      The annual Oracle users conference COLLABORATE 15 - IOUG Forum will take place in Las Vegas from April 12-16, 2015 at the Mandalay Bay Resort & Casino. This is a once-a-year opportunity to connect with the members of not one but three Oracle users groups (IOUG, OAUG and Quest) as well as with the top names and faces in the Oracle community. For more than 20 years, IOUG has delivered a unique event with leading-edge content for Oracle technology users. We fully anticipate that the COLLABORATE 15 - IOUG Forum will meet and exceed the high watermark set by COLLABORATE 14, which had over 5,500 attendees, 1,250 presentations and a full week of great events and networking opportunities. We look forward to bringing together our engaged, expert user community in April 2015! all day
  • April 14, 2015
    • Collaborate 2015Collaborate 2015
      
      The annual Oracle users conference COLLABORATE 15 - IOUG Forum will take place in Las Vegas from April 12-16, 2015 at the Mandalay Bay Resort & Casino. This is a once-a-year opportunity to connect with the members of not one but three Oracle users groups (IOUG, OAUG and Quest) as well as with the top names and faces in the Oracle community. For more than 20 years, IOUG has delivered a unique event with leading-edge content for Oracle technology users. We fully anticipate that the COLLABORATE 15 - IOUG Forum will meet and exceed the high watermark set by COLLABORATE 14, which had over 5,500 attendees, 1,250 presentations and a full week of great events and networking opportunities. We look forward to bringing together our engaged, expert user community in April 2015! all day
  • April 15, 2015
    • Collaborate 2015Collaborate 2015
      
      The annual Oracle users conference COLLABORATE 15 - IOUG Forum will take place in Las Vegas from April 12-16, 2015 at the Mandalay Bay Resort & Casino. This is a once-a-year opportunity to connect with the members of not one but three Oracle users groups (IOUG, OAUG and Quest) as well as with the top names and faces in the Oracle community. For more than 20 years, IOUG has delivered a unique event with leading-edge content for Oracle technology users. We fully anticipate that the COLLABORATE 15 - IOUG Forum will meet and exceed the high watermark set by COLLABORATE 14, which had over 5,500 attendees, 1,250 presentations and a full week of great events and networking opportunities. We look forward to bringing together our engaged, expert user community in April 2015! all day
  • April 16, 2015
    • Collaborate 2015Collaborate 2015
      
      The annual Oracle users conference COLLABORATE 15 - IOUG Forum will take place in Las Vegas from April 12-16, 2015 at the Mandalay Bay Resort & Casino. This is a once-a-year opportunity to connect with the members of not one but three Oracle users groups (IOUG, OAUG and Quest) as well as with the top names and faces in the Oracle community. For more than 20 years, IOUG has delivered a unique event with leading-edge content for Oracle technology users. We fully anticipate that the COLLABORATE 15 - IOUG Forum will meet and exceed the high watermark set by COLLABORATE 14, which had over 5,500 attendees, 1,250 presentations and a full week of great events and networking opportunities. We look forward to bringing together our engaged, expert user community in April 2015! all day

• Sign Up for our Newsletter!

• Recent Posts

  • RMOUG Training Days 2015 is the One Conference You DON’T Want to Miss!
  • Fall Quarterly Educational Workshop 2014
  • RMOUG Oracle Fusion Middleware Workshop Kickoff Meeting – Oracle SOA 12c
  • Come Learn and Play QEW – August 8th at Elitch Gardens
  • New Fusion Middleware Special Interest Group!

• Search