 |
|
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 
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
(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. |
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
- 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.
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.
Book
your class seat |
 |
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
and include the URL for the page.
