Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 
 

Oracle Performance Tuning at Sea 2018

BC training cruise for DBAs and Developers, taught by Donald K. Burleson

Sunday January 28th - Sunday, February 4th 2018

For cruise details, call (800) 766-1884 or email us at

             The Oasis Of The Seas

 

The training class cost is $1495.00 per student.

The cruise cabin cost varies depending on the cabin level you choose. Cabin prices start at $820.00 per passenger for an inside cabin.

Book your class seat  Buy a seat in the Oracle Training Class at Sea  

START YOUR ORACLE CRUISE ADVENTURE NOW:

The world's best Oracle training comes from practicing Oracle consultants, real Oracle experts and authors who combine years of experience with outstanding communications skills.  The problem is that the top Oracle experts are busy working with mission critical databases and rarely do public training. 

Only once per year, Burleson Consulting offers a public training class, a rare opportunity to learn the secrets of Oracle from some of the world's most highly regarded Oracle experts and authors, people who have managed some of the world's largest and complex databases.


Don Burleson Lecturing on a Cruise

Beautiful amenities on board

The Appeal of a BC Oracle Cruise

This is a full 7-night Cruise with an onboard Oracle Performance tuning class, all for less than the cost of a traditional training class. Cruise prices are at an all-time low, and this is an unprecedented opportunity to combine the vacation of a lifetime with world-class Oracle DBA training.  In past years, BC has had great success with our shipboard Oracle cruises, a great way to have fun and share valuable Oracle technical information.

TOP

There are many benefits to our land-sea Oracle training:

  • World class education:  Donald K. Burleson is one of the best known Oracle experts in the world, author of more than 30 books.  This is a not-to-miss opportunity for expert advise for working DBA professionals.  Unlike traditional Oracle DBA training, the BC Oracle DBA training is taught by a practicing Oracle DBA consultants with more than three decades of hands-on, real-world SQL tuning experience. 
     
  • Bring the family:  Your loved ones can share your stateroom for as little as $820 per person, making the BC Oracle cruise the most affordable training option anywhere. 
     
  • Convince the boss:  See these important notes on how to convince your boss the BC cruise is a great value.   

Book your class seat  Buy a seat in the Oracle Training Class at Sea 

(TOP)

  • Bring the team - This is a phenomenal team building opportunity!  Discounts are available for multiple attendees from the same company.

    Students

    Cost each

    1

    $1,495

    2

    $1,325

    3

    $1,265

    4

    $1,195

    5

    $1,130

    6

    $1,065

    7+

    $   995


  • Traditional invoicing:  Because the training is not at any fixed place, the Oracle class invoices are shown as being conducted in Orlando, Florida, where the class begins.
     
  • Great Value - The BC Oracle DBA cruise is better quality training at an even better price.  The BC Oracle cruise is far less expensive than a traditional Oracle DBA class, with an unparalleled intimate learning experiences.  Compare your options, and you will see why the Oracle cruise is a no-brainer!
  Vendor  Course Travel Room Total Cost
  Oracle University  $3,750  $600  $1,000 $5,300
  BC Oracle Cruise

 $1,495

$600  $1,000 * $3,095

* Cruise fares start as low as $820 per person

TOP


Meet your trainer:

   
Donald K. Burleson is one of America's best known Oracle experts and authors. 

A retired Adjunct Professor Emeritus, Burleson has more than 30 years of full-time DBA experience, authored more than 30 Oracle database books, written over 100 Oracle articles, and serves as Editor of Rampant TechPress.


TOP

About the BC Oracle cruise

On January 2018 we will set sail for the eastern Caribbean cruise of a lifetime.

We are sailing on the Oasis of the Seas, one of the world's largest cruise ships.

For Oracle cruise details and booking information,

Day

Arrive

Depart

1.Port Canaveral, Florida

--

4:30 PM

2. At Sea

 

 

3. At Sea

--

--

4. Philipsburg, Netherlands Antilles

8:00 AM

5:00 PM

5. San Juan, Puerto Rico

7:00 AM

2:00 PM

6. Labadee, Haite

--

--

7. At Sea

--

--

8. Port Canaveral, Florida

6:15 AM

--

Enrolling in the Oracle Performance Tuning class

- Step 1: Book your class seat with BC  Buy a seat in the Oracle Training Class at Sea 


- Step 2: Book your cruise cabin directly with Royal Caribbean  



- Step 3: Book the hotel of your choice in Orlando, Florida for the night preceding the cruise

TOP



About the Oracle Performance Tuning Training class

This is an intensive 3-day (18 classroom hours) training class on Oracle Performance tuning.  This class is aimed at Oracle DBAs and Oracle developers, an opportunity to get an in-depth functional understanding into the performance tuning of complex Oracle database systems from a leading tuning expert.

Topics include the full curriculum from our popular Oracle Performance tuning class.  You will need to bring a laptop with Oracle installed if you wish to participate in the class exercises.

Advanced Oracle Performance Tuning
Three Day Syllabus

(c) 2017 by Donald K. Burleson

Introduction

This section introduces participants to a series of tuning steps that can be used to improve the performance of the Oracle Server. The focus is on database issues rather than specific operating system performance issues. Students will learn how to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.

In conjunction with the other four courses in the Oracle Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle: Performance Tuning, part of the Oracle DBA certification track.

Learning Objectives - After completing this course, students will be able to:

  • Apply sound database design principles to ensure high performance
  • Identify appropriate metrics and tuning goals for measuring and monitoring performance
  • Identify the critical performance tuning steps
  • Interpret Oracle alert files
  • Use Oracle trace files
  • Use Oracle utilities for performance tuning
  • Use the V$ utilities for tuning
  • Employ tuning techniques for different types of applications

 

Tuning the Oracle instance and objects

This section takes an in-depth look into the memory internals of the Oracle SGA. Students will learn how to identify and diagnose Oracle memory performance problems, including problems in the library cache, data buffer cache and data dictionary cache. Once students complete the second course, they’ll be able to handle any SGA-related slowdown, and will have a set of pre-written SQL scripts that they can use to quickly identify performance problems.

In conjunction with the other four courses in the Oracle Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle: Performance Tuning, part of the Oracle DBA certification track.

Learning Objectives - After completing this course, students will be able to:

  • Tune the Oracle shared pool
  • Tune the data buffer cache
  • Tune Oracle rollback segments
  • Tune Oracle redo mechanisms Monitor and detect lock contention
  • Identify Oracle sort operations

This area will examine the behavior of the Oracle instance and look into the behavior of the Oracle background process and the SGA memory.  The topics for this section will include iterations of recommendations for changes to init.ora parameters, changes to redo log and rollback segments, and changes of physical file locations on disk. 

Oracle Instance Tuning

This section will also explore how to measures changes to the SGA performance and how to document the performance improvements.  

  • Redo Logs – This section to introduce the performance characteristics of the Oracle online and archived redo logs.
     

  • UNDO (Rollback) segments – This section explores the interaction between the Oracle rollback segments and the performance of the Oracle database.
     

  • Data Buffer management - Buffer management issues will include the performance of Oracle with various values of db_block_size and the proper settings for db_block_buffers.  This section will also look at allocation of the DEFAULT, KEEP and RECYCLE pools.
     

  • Shared pool issues – This section will discuss the management of the components of the shared pool with a focus on the management of activity in the library cache.
     

  • Sorting issues – This section will describe the management of the sort_area_size parameter and how to determine the optimal setting for disk versus memory sorting.
     

  • Default SQL optimizer mode – This section will explore the optimizer_mode initialization parameter and how the default parameter can effect the database performance.
     

  • Miscellaneous Initialization parameters – Other init.ora parameters such as cursor_space_for_time will be discussed.
     

  • Concurrency Management - This will describe Oracle's serialization and locking schemes and show how to manage locks.

Oracle object tuning

This area will include recommendations relating to the creation of new indexes, removing migrated/chained rows and the re-sequencing of popular tables into index order to reduce I/O.   The focus will be on the tradeoff between efficient space management and high performance of select and insert SQL statements

  • Oracle index internals – This section will explain the relative benefits for b-tree, bitmapped and function-based indexing.  This section will also explain how to analyze indexes to determine those indexes that require re-building.
     

  • Oracle replication – This section will explore Oracle replication and explain the ramifications of replication versus database links for distributed data.
     

  • Oracle segment internals – This includes the high-water make and the effect on full-tale scans after deletes.  This section also includes a section on the pctused parameter and the effect on space re-use and the performance of subsequent insert statements.  There will also be a discussion of pctfree and how pctfree can be used to avoid row chaining.  The freelists parameter will also be discussed with respect to buffer busy waits, and the freelist_groups parameter will be discussed for Oracle parallel Server.
     

  • Object access patterns – A technique will be introduced to explain all of the SQL in the library cache.  This technique is indispensable for identify long-table full-table scans, identifying small tables for caching.

 

Tuning Oracle Data access

This section takes an in-depth look into the concepts and skills needed to tune Oracle with SQL Students will learn about the broader issues of tuning with SQL, and then delve into tuning with the Optimizers, the Explain Plan Utility, Hints, and other tuning techniques. After completing this course, students will be able to tune all Oracle SQL and take the actions required to ensure optimal SQL performance.

In conjunction with the other four courses in the Oracle Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle: Performance Tuning, part of the Oracle DBA certification track.

Learning Objectives - After completing this course, students will be able to:

  • Define the major features of Oracle SQL
  • Tune using ANSI extensions
  • Tune using the Explain Plan Utility
  • Understand SQL Optimizer modes
  • Tune using the rule-based optimizer
  • Tune using the cost-based optimizer
  • Tune using SQL hints

This area will examine all of the SQL within the Oracle library cache and determine the best opportunities for tuning of SQL.  The focus on the SQL tuning will be to tune the most frequently executed statements first, and move down the list as time permits.  The areas for SQL tuning will be to optimize execution plans by removing unnecessary full-table scans, fully utilizing indexes, and implementing advanced hints to derive the optimal execution plan for each query.  This may also involve replacing native SQL with PL/SQL procedures.  Tuning SQL statements using Oracle “hints” will be explained and techniques for testing SQL in a separate instance to determine the optimal execution plan and minimal run time will be explored. 
 

  • Cost-based vs. Rule-based optimization – See the relative benefits of cost-based vs rule based optimization and see when to use rule and cost hints.

  • Tuning with indexes – Learn a technique for identifying unnecessary full-table scans

  • Tuning sub-queries –See the optimal execution plans for subqueries with the IN clause

  • Tuning with hints – See the techniques for using the use_hash, use_aj and other important Oracle tuning hints.

  • Tuning with Parallel query - This section describes how parallel query works, and how to best provide parallelism for Oracle.

 

Tuning the external environment

This section will teach students about external influences on Oracle performance, how to measure them, and how to ensure that the external environment is properly configured for Oracle. Students will learn how to take advantage of all the UNIX-based tools for monitoring, configuring, and tuning the external environment. The course also covers tuning issues related to the operating system, tuning for effective CPU usage, reorganizing tables to improve I/O performance and more.

The next section will focus on identifying and correcting external influences including RAM memory shortages, disk I/O bottlenecks, and CPU shortages.  The external environment will be monitored using the vmstat and iostat utilities.  This section will discuss the iterations of recommendations relating to environmental tuning such as OS dispatching priorities, swap space allocation, and other OS-specific issues. 

  • vmstat utility – Interpreting the runque, page-in and the CPU metrics.

  • iostat utility – Using the iostat utility to determine disk I/O access patterns and I/O bottlenecks.

This section will also includes an easy method for capturing environmental statistics inside Oracle tables for long-term analysis.

In conjunction with the other four courses in the Oracle Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle Performance Tuning, part of the Oracle DBA certification track.

Learning Objectives - After completing this course, students will be able to:

  • Define the major features of Oracle SQL
  • Tune using ANSI extensions
  • Tune using the Explain Plan Utility
  • Understand SQL Optimizer modes
  • Tune using the rule-based optimizer
  • Tune using the cost-based optimizer
  • Tune using SQL hints

 

Advanced Oracle Tuning Concepts

This section introduces students to advanced Oracle performance tuning tools and concepts associated with Oracle, and is designed to give students the skills to maximize the performance of their Oracle database.

In conjunction with the other four courses in the Oracle Performance Tuning Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-014, Oracle: Performance Tuning, part of the Oracle DBA certification track.

Learning Objectives - After completing this course, students will be able to:

  • Use data blocks efficiently to improve I/O performance
  • Tune using the new Oracle Data Structures
  • Use the Data Dictionary to monitor performance
  • Define and use Oracle table and index partitions
  • Tune with Oracle indexes for optimal performance
  • Tune Oracle for Web Applications
  • Describe and implement tuning techniques for Distributed Databases
  • Tune the Oracle Parallel Server (OPS)

Prerequisites

In order to get the most from this course, students should have a basic understanding of the UNIX operating system, PL/SQL coding techniques, and the following Oracle database concepts:

  • Oracle tables and tablespaces
  • Oracle instances
  • Oracle data dictionary

 

   

Why learn Oracle on a cruise?

This is the best Oracle DBA training course anywhere, plus the learning environment is substantially enhanced by the "at sea" experience.  You will have nearly countless opportunities to interact with your expert instructor, an experienced Oracle DBA.

  We are limiting enrollees to ensure that every student gets personalized attention.

Book your class seat  Buy a seat in the Oracle Training Class at Sea 

For Oracle cruise details and booking information, send an e-mail to

Plus, you can bring your family, sharing your stateroom, combining your training with the ultimate family vacation. 

 

This is an unparalleled opportunity to learn Oracle DBA from working Oracle DBA experts.  We are only accepting a limited number of attendees, so call and reserve your spot now in this amazing Oracle DBA training.  Or visit the shopping cart where you can reserve your class seat online.
B
ook your class seat  Buy a seat in the Oracle Training Class at Sea 

TOP

BC Oracle Cruise Feedback

Paulo Portugal

?
Thank you for the amazing opportunity  to meet you, Janet, Robin, John, Steve and the BC group in person.  With this course I reached one of my dreams that was to learn from you and your team."

John O:

Great transfer of knowledge. [Having the training] on a cruise ship is great for networking.


Pete M:

Great! Hit on several tuning tips that we can quickly implement.


Tom P:

Fantastic! I learned something new each session that [was] beneficial.


Kevan R:

[The BC crew] answered questions I needed to roll out a Data Warehouse project.


Bill S:

Great! Course venue wonderful, networking opportunities good, ship great!

TOP


   

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 




Hit Counter

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational