Calendar

Month: Year:
« Prev March 2015 Next »
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1
* 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.

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

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

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

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

6
7
8
9
10
* ODTUG Free WebinarODTUG Free Webinar

Time: 1:00 pm

Unstructured Data: Database or File System? The Debate Continues Marcelle Kratochvil, Piction Tue, Mar 10, 2015 1:00 PM - 2:00 PM MDT 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.

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

11
* 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!

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

* 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!

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

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

15
16
17
* ODTUG Free WebinarODTUG Free Webinar

Time: 10:00 am

Oracle Application Express 5.0 New Features Joel Kallman, Oracle Corporation Tue, Mar 17, 2015 10:00 AM - 11:00 AM MDT This session will provide an overview of the major new features being delivered in Oracle Application Express 5.0. The main goal of Oracle Application Express 5.0 is to improve developer productivity See how the many improvements to both the Application Builder and the components you can use to build applications can make it even faster and easier to exceed your customers’ business requirements when building web applications with Oracle Application Express.

* IOUG Free WebinarsIOUG Free Webinars

Time: 11:00 am

Consolidating Databases and Applications on ODA X5-2 Tue, Mar 17, 2015 11:00 AM - 12:00 PM MDT Looking for IT consolidation or the ability to deploy a complete application on a single system? The new Oracle Database Appliance X5-2 has more resources that provides the ability to rapidly and simply deploy a highly available database in hours with a single command. Join us to learn why the Oracle Database Appliance is the platform to deploy critical applications and how it can reduce your TCO. What will you learn? - Find out about the new Oracle Database Appliance X5-2 enhancements - Discover how easy and fast a complete application stack can be deployed on ODA - How does ODA lower your TCO Featured Speaker: Tammy Bednar Oracle Corporation

18
* Oracle DB Innovation OnlineOracle DB Innovation Online

Time: 11:00 am

Database Innovation Online Forum March 18th, 2015 10:00AM PST/1:00PM EST Are you leveraging Oracle's database innovations for Cloud and Big data? Tom Kyte will describe what’s new in Oracle Database 12c along with the top reasons customer choose Oracle including best practices for optimal performance and availability. Following the keynote, access any of the 10 breakout sessions, with content specifically designed for: - Senior IT Management - DBAs - Enterprise Architects Register today to hear the latest about Oracle Database innovations and best practices. Featured Speakers: Oracle Corporation: Tom Kyte, Oracle Database Architect Epsilon: Keith Wilcox, VP - Database Administration CCC Info Services: Bill Callahan, Director, Principal Engineer

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

* C-Level @MileHigh conferenceC-Level @MileHigh 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.

* ODTUG Free WebinarODTUG Free Webinar

Time: 1:00 pm

Navigating the EPM Roadmap: Mapping EPM from Business to Infrastructure Jeff Henkel, CheckPoint Consulting Thu, Mar 19, 2015 1:00 PM - 2:00 PM MDT This presentation will demonstrate how the Oracle EPM (Hyperion) Suite aligns with strategic IT goals and integrates with pre-existing IT processes and flows, with the goal being to demonstrate that IT strategy and business-driven software/applications are driving in the same direction.

20
21
22
23
* Hotsos Online TrainingHotsos Online Training

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

24
* Hotsos Online TrainingHotsos Online Training

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

25
* Hotsos Online TrainingHotsos Online Training

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

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

26
* Hotsos Online TrainingHotsos Online Training

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

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

* IOUG Free WebinarsIOUG Free Webinars

Time: 10:00 am

12 Months of Database 12c: Oracle Database 12c In-Memory – An Optional Feature That Is Actually Essential Thu, Mar 26, 2015 10:00 AM - 11:00 AM MDT The In-Memory Option for Oracle Database 12c became available 12.1.0.2 database patchset, opening a world of possibilities as far as performance improvement. For companies with a strong need for improved retrieval and analysis speeds (which is everyone), this could be a huge breakthrough, but what does this mean for your current systems? Can you support the RAM requirements? And what happens to all of your current disk storage? During this session, you’ll hear from Oracle’s chief in-memory expert Maria Colgan, and Oracle ACE Christo Kutrovsky about the best ways to start taking advantage of the in-memory option, how this differs from a pure in-memory database, and what it means for your current future systems needs planning. This will be an interactive dialogue, so please bring your questions; whether you’re just getting acquainted with in-memory or you have specific technical questions.

* ODTUG Free WebinarODTUG Free Webinar

Time: 1:00 pm

Look Inside the Locking Mechanism Liron Amitzi, Brillix Thu, Mar 26, 2015 1:00 PM - 2:00 PM MDT Locking issues have always been an interesting topic. This is one of the most important features that maintain the integrity of our database. Why do we need the locking mechanism? What locking modes and types are there? What does Oracle lock during DML and DDL operations? How are constraints and indexes affected by and affecting locks? These are some of the questions this session handles. The session also includes live demos for some advanced and interesting scenarios, and shows how to query relevant data dictionary views.

* Denver Tableau User GroupDenver Tableau User Group

Time: 2:00 pm

Join us for the Q1 2015 Denver Tableau User Group meeting online! Agenda: ======= --> 2:00 p.m. - Data Blending and Advanced Analytics with Tableau and Alteryx Bo Licalzi / ViaSat, Inc., Systems Engineer – ATG Data Sciences Darren Bycoff / Director of Strategic Alliances at Alteryx . --> 3:00 p.m. - Advanced Table Calculations - Go Deep! George Peck / Ablaze Group

27
* Hotsos Online TrainingHotsos Online Training

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

28
29
30
* 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.

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

* ODTUG Free WebinarODTUG Free Webinar

Time: 10:00 am

Oracle Application Express 5.0 Page Designer David Peake, Oracle Corporation Tue, Mar 31, 2015 10:00 AM - 11:00 AM MDT The Application Express 5.0 Universal Theme will fundamentally change how you define the user interface. Learn how to use the new styles, template options, and theme roller to readily change the look and feel of your applications.

* IOUG Free WebinarsIOUG Free Webinars

Time: 11:00 am

Oracle Health Checks Using APEX Tue, Mar 31, 2015 11:00 AM - 12:00 PM MDT With the heavy workload that most, if not all, DBAs face, it's no wonder there is little time left to perform routine health checks. The presenter will discuss the real value of health checks, based on the thousands of them performed for clients. Also, find out what the best practices are for health checks and how to use APEX to standardize health checks across multiple customers and unlimited installed configurations. Featured Speakers: Chuck Ezell, Datavail

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