Oracle Corporation

Real Application Testing

Advanced Hands-on Workshop

Dieses Training findet in englischer Sprache statt. Die Teilnahme ist ausschließlich Oracle Partnern mit einer gültigen Oracle PartnerNetwork Mitgliedschaft vorbehalten, und unter Beachtung der aktuellen Teilnahmebedingungen, kostenlos.

Date: 18.-19. December 12012
Location: Oracle Munich, Germany
Audience: Oracle Customers, Partner

Oracle Database Releases 11g and 12c provide significant improvements in operability and manageability. However, until customers upgrade their existing installations, they will not be able to take advantage of these new features and options. The purpose of this workshop is to enable Oracle Partners and Customers with hands-on Real Application Testing expertise so they can plan and smoothly transition to new releases and technologies.

Real Application Testing can be used as a technology “enabler” to test a variety of infrastructure changes, from optimizer statistics refresh validation, compression, RAC, ASM, Exadata V2 migration to consolidation of databases, all of which will lower the costs for customers. Enabling customers and partners with Real Application Testing expertise is an important part of Oracle's strategy to help customers to adopt new technologies and have a better experience while embracing these solutions.

In the workshop, we will provide valuable insight into the building blocks of SQL Performance Analyzer (SPA) and Database Replay, their internals, and when and how best to use each of these features, including hands-on training. The session also provides tips on how to interpret key SPA and Database Replay reports and how best to remediate the performance bottlenecks identified in testing before the system changes are deployed successfully in production.

Content: This is intended for practitioners’, i.e.,

  • Instructor-led education with theory and practice
  • Labs performed individually or in teams of two

The workshop incorporates theory to explain concepts, techniques etc., and practical exercises with realistic scenarios.

Topics include:

  • Recommended testing methodology and associated best practices
  • SQL Performance Analyzer - testing in production as well as test environments
  • End-to-end automation of Database Replay workflows
  • Interpretation of Database Replay and SPA reports
  • Oracle Database 12c workload scale-up solutions
  • Testing database consolidation
  • Secure Database testing using Data Masking

Workshop Prerequisites:

  • Good DBA skills - this is hands-on!
  • Good general understanding of performance analysis and tuning

Equipment/Laptop Prerequisites:

Bring you own laptop - you'll use it for the lab exercises by connecting to the servers and creating an Oracle Virtual Box VM on it.

  • At least 2GB Free RAM
  • At least 20GB of free space (Note: virtualization works best with contiguous space so it is a good idea if on Windows to run a defrag program, and make sure you are using NTFS for your file system to handle large files on Windows)
  • 2GHz Processor (a lesser processor will be acceptable but slower)
  • Mozilla Firefox 2.0 or higher, Internet Explorer 7 or higher, Safari 3.0 and higher or Google
  • Chrome 1.0 or higher
  • Adobe Acrobat reader
  • Admin privileges on your box

You’ll also need your individual unique OTN account to use the labs.

Who will lead the event?
The workshop will be led by Product Management team from ST Product Development.

Duration: 2 Days, 1st day: 09-17:00 CET/ 2nd day: 08:30-16:30 CET

Oracle Hauptverwaltung Muenchen
Riesstraße 25
D-80992 München

You will need to book your own accommodation and settle your own bill for lodging.
Hotel recommendations:
Innside München Parkstadt Schwabing
Mercure Hotel München am Olympiapark
NH München Deutscher Kaiser

Please contact to register for this class. A maximum of 15 seats is available.


Hardware and Software Engineered to Work Together
Copyright © 2012, Oracle. All rights reserved. Contact Us | Legal Notices and Terms of Use | Privacy Statement

Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL - E-mail Services, Redwood Shores, CA 94065, United States

Create or update your profile to receive customized e-mail about Oracle products and services.

If you do not wish to receive any further electronic marketing communications from Oracle you can Opt-Out completely, please note you will no longer receive newsletters and product information you may have subscribed to.