Oracle Expert Seminar

Our selection of Expert Seminars for you:

Please mention this code at the time of booking: E1228

divline

About
Oracle University
Expert Seminars:

Oracle University Expert Seminars are exclusive events delivered by top Oracle experts with years of experience in working with Oracle products.

divline
fbVisit our Facebook page
twitterFollow us on Twitter
linkedinJoin our LinkedIN Group
google+Find us on Google+

Expert Seminar - Oracle Database 11g


Beating the Optimizer with Jonathan Lewis
17-18 January 2013

Jonathan Lewis This is a follow-on from the course “Designing Optimal SQL”, and focuses on writing SQL to emulate transformations that are currently not available to the Oracle Optimizer.In this session you will examine a very simple join and note a fundamental limitation in the optimizer’s ability to find the best strategy for joining two tables. You will see how you can overcome this limitation – at a cost of more complex SQL – and look at the way you need to think about joins to minimize the work you do, noting that the possible benefit isn’t always as great as you might first think.

1
Register Now
1
divider

RAC Performance Tuning On-Line with Arup Nanda
25 January 2013

Arup NandaThe “Performance Tuning in RAC” seminar is spread over 4 modules of total 8 hours and aims exclusively at training the Oracle DBA in improving the performance of the RAC system. The foundation of any tuning depends heavily on the proper diagnosis. So, this seminar starts with the building the knowledge on the RAC system, with respect to performance, and gradually prepares the student to unravel the mysteries surrounding performance issues.

1
Register Now
1
divider

Mastering Oracle Parallel Execution with Randolf Geist
30 January 2013

Randolf GeistIn order to process large amounts of data as quickly as possible and leverage the capabilities of today's hardware Oracle offers its Parallel Execution feature as part of the Enterprise Edition license. There might be a lot of cases where simply adding parallelism to a statement execution doesn't deliver the expected reduction in runtime. It's therefore crucial to understand how Oracle Parallel Execution works, what its building blocks are, what kind of diagnostic possibilities are offered to systematically analyze Parallel Execution performance and how to apply appropriate measures.

1
Register Now
1
divider

Minimize Downtime with Rolling Upgrade using Data Guard with Uwe Hesse
8 February 2013

Uwe HesseStarting with 10g, Logical Standby Databases offer a method to minimize the downtime related to a Database Upgrade to the time it takes to do a switchover. This Seminar covers Rolling Upgrades with Logical Standby - in place already or created for that purpose – as well as Rolling Upgrade with a present Physical Standby. Rolling Upgrade procedures, processes and its restrictions are explained. All system requirements will be covered, as well as backup and fallback procedure.

1
Register Now
1
divider

Understanding Explain Plans & Index Utilization Online
with Dan Hotka
16-17 April 2013

Dan HotkaThis session starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. The trainer will illustrate various coding techniques that insure the SQL runs at maximum performance in the current and future Oracle database environments and cost-based statistics that are useful to improve SQL performance and index selection as well. Understanding how Indexes work and when to use the different kinds of indexes is critical to both individual SQL performance and the overall batch cycle performance.

1
Register Now
1

For a full list of Oracle Expert Seminars near you or on line click here.

For assistance contact your local Oracle University Service Desk.


Please mention this code at the time of booking: E1228
Hardware and Software, Engineered to Work TogetherOracle University
Copyright © 2012, Oracle and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices and Terms of Use | Privacy Statement
SEV100129451