MEET INTERNATIONAL ORACLE DATABASE SPECIALISTS AND IMPROVE YOUR SKILLS

Trivadis is very pleased to organize in Zurich another outstanding seminar with top guest speakers. This year’s focus will be on Oracle Database performance and query optimization.
Since performance is not simply a product one can buy but rather the results of an accurate planning and a correct implementation, the seminar will present valuable techniques not only for troubleshooting performance problems, but also to avoid them in first place.

WHAT YOU WILL LEARN

Performance Days will provide a lot of valuable and practical information to diagnosing, resolving and avoid performance problems in applications involving Oracle Database.
The speakers will cover topics such as:

  • New optimizer features in Oracle Database 18c
  • How To Correctly Use AWR Reports
  • Thorough look at how external tables work
  • Most common reasons why the optimizer doesn't select appropriate indexes
  • Problems and workarounds related to object statistics
  • Leveraging Data Guard features beyond data protection
  • In-depth look at the trace files generated by event 10053
  • How Oracle Database really manages space inside tablespaces
  • Identifying performance problems in a Multitenant environment
  • What Oracle's in-memory databases can do

FLYERAGENDA

TVDPDAYS

Duration

2 days

contents

SPEAKERS

The lineup of speakers comprises renowned consultants and experts as well as members of the development organization at Oracle. All of them share the same enthusiasm in advocating about database-related technologies.

THE SESSIONS

I often get called in by customers to determine and address the root cause of database performance issues. Depending on the issue, a request for a simple Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem. Using a number of Real-World AWR examples, I discuss how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures you can quickly determine whether an AWR report will be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues.
This session presents what’s new in the optimizer for Oracle Database 18c. It covers new and enhanced features such as improved statistics management, performance enhancements and plan stability. Worked examples demonstrate how these features are controlled and used, along with examples of how they can be expected to affect workload performance.
We will spend just a few minutes on a basic review of how to read execution plans using the traditional "first child first, recursive descent" (or "near the top and over to the right") method before moving on to more sophisticated details including

(a) recognising when this rule doesn't apply and
(b) understanding that the JOIN order doesn't always match the EXECUTION order and
(c) realising that WHAT happens is only part of the problem, and HOW MANY TIMES it happens is important and can be understood.

We make time time to look at the effects of scalar subqueries, common table expressions, partitioning and parallel execution.The tools we cover will include a couple of trace events (other than 10046), the parallel query execution stats (v$pq_tqstat), rowsource executions stats, and SQL monitoring.

To get the most out of the multitenant architecture available in Oracle Database 12c/18c, it is not only necessary to know its features from a technical point of view, but sometimes it is also necessary to change the way some tasks are carried out. In fact, dealing with an additional layer introduces new challenges and possibilities. The aim of this session is to discuss how to identify performance problems from the command-line and through Enterprise Manager 13c when multitenant architecture is involved. Specifically, it covers what you have to consider, and what the differences are compared to non-multitenant architecture, when gathering and analyzing the performance data provided by dynamic performance view, AWR, and SQL trace.
When someone requests help on the Oracle forums to address the problem of a query picking a bad execution plan, one of the commonest (and most rapid) responses is the suggestion to make sure the statistics are up to date. Sometimes this will solve the problem, sometimes it won't solve the problem but will produce a change that makes it easier to identify the problem, sometimes it just won't help at all.
"Up to date" statistics, "accurate" statistics, and histograms aren't necessarily what you need to get Oracle to produce the execution plan you want, and in this presentation we look at some of the ways in which "good" statistics are not "good enough", and come up with some strategies for recognising when we have to work around Oracle's statistics and how we can work around them with the minimum of effort and risk.
In this session Roger and Chris will explain the architecture of Oracle's two main in-memory database technologies; Oracle Database In-Memory and Oracle TimesTen. They will also discuss the pros and cons of these two quite different technologies, which use cases do best with each and why, and tips and tricks for the DBA to get the best performance out of each.
Using Oracle Data Guard just for data protection means using less than half of its potential. Oracle Data Guard is included with Oracle Database Enterprise Edition: leveraging it full can increase the return of investment.
This session will give a brief overview of the client failover technologies and focus on some Oracle Data Guard features that can be used for common tasks such as database cloning, database migration and reporting. Live demoes will complete the experience.
One of the great advantages of using a query optimizer is getting your SQL translated transparently into something better! The Oracle CBO is capable of transforming a SQL several times even for just a simple statement.
This is probably why analyzing a CBO trace (event 10053) is painful and scary to many, who likes to read 100k lines of raw trace?
This session focuses on the mechanics behind the CQBT framework and shows an analytical approach to digest any CBO trace file decomposing it into smaller pieces, easy to analyze.
It has long puzzled me that I've never seen Oracle External Tables as a talk at any OUG but they are an essential part of any DBAs arsenal.
Oracle External Tables have become much richer and more complex in the last five years with the addition of
  • ORACLE_HIVE and ORACLE_BIGDATA drivers, and Big Data SQL
  • Partitioned external tables
  • In -Memory External Tables
  • Some exciting new features expected in 18c

This talk aims to review the basics and also review the rich syntax options up to and including 18c.

In particular, we will discuss: the different driver types, security, datatype conversions, character set mismatch, performance, and parallel query. We will also review what is available for the DBA to monitor external tables with the data dictionary, tracing, wait events, and statistics.
There are a lot of myths and legends about storing segments in tablespaces - should we keep indexes separated from the tables? Can we stop worrying about segment fragmentation? What is a real difference between MOVE and SHRINK? At this session, I will present you my free C++ tool to visualize the contents of the datafile. We will disassemble a database block and try to understand how Oracle is really managing space inside tablespaces.
This session will discuss in detail some of the more common reasons why what might seem appropriate indexes are not automatically used by the CBO or if they are used, can result in suboptimal performance. The issues are often in relation to how the data is actually physically stored within the table or indeed how the CBO thinks such data is stored. We look at determining what the root issues might be and then discuss a number of methods, including those possible now with 12.2 in addressing them to potentially dramatically improve overall performance. The session covers a number of interesting examples, including one in which the CBO would not use an index to retrieve just 0.15% of data, but would later to retrieve the entire 100% of a table.
With its Autonomous Data Warehouse Cloud (ADWC), Oracle promises a self-configuring, fast, secure, and scalable platform for data warehouses. The installation takes place with few mouse clicks, and a much easier development and operation of a data warehouse is assured. Things like upgrades and patches, backups, performance optimization, scaling, indexing and partitioning, materialized views, optimizer statistics, and other "trivia" are no longer a concern of the customer.
The marketing statements sound tempting - or scary, depending on the starting position. But what is really behind it? What happens when we run our data warehouses with ADWC? Which tasks are simplified or superfluous? What effects does the self-configuring cloud solution have on database design, ETL processes, and BI queries?
Based on various typical applications from the data warehouse area, we tested the ADWC to know where in the future we still need, or can, influence ADWC and which tasks in the construction and operation of a data warehouse will be eliminated or simplified.

WHEN IT IS PLANNED

19.-20. September 2018
The working day will be from 9am to 5pm; and on the evening of 19th there will be an opportunity to share your experiences and opinions with the speakers and other participants in a less formal atmosphere as we meet over drinks from 5pm to 7pm.

LANGUAGE

The seminar will be conducted in English.

TARGET AUDIENCE AND REQUIREMENTS

Target audiences of this event are performance analysts, database administrators, application developers, as well as consultants who want to improve their skills in managing performance or developing database-backed applications involving Oracle Database.
Participants are expected to have a working knowledge of Oracle Database.

LIVE OR ONLINE

Join us either live in Zurich or attend the sessions online in our virtual classroom. All sessions will be available as live stream for you. Requirements: access to the internet and headset. You will receive your personal account prior to the event. The account is valid for one person.

Special offer

Conference Ticket: 1,950 CHF

Price for the 2nd participant from your company - 1463 CHF
Price for the 3rd participant from your company - 975 CHF
Price for the 4th and every other participant from your company - 488 CHF

Online Ticket: 1,650 CHF
Price for the 2nd participant from your company - 1238 CHF
Price for the 3rd participant from your company - 825 CHF
Price for the 4th and every other participant from your company - 413 CHF

VENUE

The event takes place at the Kameha Grand Hotel Zurich, Switzerland.
www.kamehagrandzuerich.com/en/contact/

PRICE

Live in the Kameha Grand Hotel, Zurich, Switzerland: CHF 1,950 / .2083 USD*

This price includes lunches and refreshments during the breaks.

Live Stream: CHF 1,650 / .1763 USD*

The live stream will be recorded. This price includes access to the recordings exclusively for you.

Our Quality Promise

Contact to our service center

DE+49 (0) 711 90363245

CH+41 (0) 584 595795

AT+43 (0) 133 2353160

FR+41 (0) 584 595454

EN+49 (0) 711 90363245

DA+49 (0) 711 90363245

emailTraining@trivadis.com

PlaceDateLanguageprice 
back to trainings
0 items in cart
Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

  • Solution Manager Trivadis Training
  • DE: +49 (0) 711 90363245
    CH: +41 (0) 584 595795
    AT: +43 (0) 133 2353160
    FR: +41 (0) 584 595454
    EN: +49 (0) 711 90363245
    DA: +49 (0) 711 90363245

    E-Mail: Training@trivadis.com

    “I'll be glad to advise you on topics such as individual coaching, workshops, project support, and online training courses.”

    Your Bernd Rössler

Arrange a training consultation now

In order for us to be able to inform you by telephone or e-mail about Trivadis offers and products in the future, we require your consent. Your consent is voluntary and you can revoke it at any time without giving reasons informally by telephone, in writing or by e-mail at info@trivadis.com. We might forward your personal data to a call centre so that we can contact you and inform you about Trivadis products and offers.

trivadis training satisfaction guarantee

Guarantee of quality

Following completion by the participants, every single training course is assessed at the levels

  • suitability of the training room,
  • suitability of the workplace,
  • functionality of the technical equipment, and
  • satisfaction throughout the entire course / seminar,

and recorded in our "TRIVALUATION" feedback system for quality assurance purposes. This enables us to consistently ensure the high quality and satisfaction of our valued customers. We really appreciate the overall rating of 9.3 from 10 points awarded by our many enthusiastic customers.

 

trivadis training success guarantee

Success guarantee

Trivadis guarantees the success of your training. Having completed the course / seminar, do you have any questions about the practical aspects? Would you like to repeat any of the exercises in the lab environment?

Our success guarantee allows you to repeat individual days, or even the entire training course, free of charge for up to 6 months after attending a training course. You bring with you the course materials from the previous training course.