> > > D87438

Parallel Processing in Oracle Database 12c (D87438)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

After completing this seminar, you'll understand the benefits of parallelizing requests in an Oracle 12c database. You'll also be able to use features of parallel processing introduced in Oracle 11g Release 1 and 2.

Learn To:
  • Optimize SQL statement execution using parallel processing.
  • Use parallel processing appropriately to derive a benefit over serial processing.
  • Control the use of parallel processing.
  • Use a variety of features for parallelizing statements.
  • Read execution plans of parallelized statements.
  • Troubleshoot different issues associated with parallel processing.
  • Use, control and manage parallelization.
Benefits To You

Through focused lessons and hands-on demonstrations, expert Oracle University instructors will teach you when and why parallel processing is relevant and effective. You'll also explore specific configurations like RAC database and Database Machine.

Zielgruppe

  • Data Warehouse Administrator
  • Application Developers
  • Database Administrators
  • Developer

Kursziele

  • Use Database Resource Manager to complement the control of parallel processing usage
  • Define why and when to use parallel processing
  • List the SQL statements and data loading utilities that can benefit from parallel processing
  • Explain the basic concepts and theory associated with parallel execution
  • Use a variety of parallel execution features with different SQL statements
  • Read and evaluate execution plans for parallelized statements
  • Use parallel processing features including Auto DOP, statement-queuing, and in-memory parallel execution
  • Examine specific configurations such as RAC database to and Database Machine with parallel execution
  • Troubleshoot parallel processing issues such as no parallel execution, unexpected DOP, or performance decrease
  • Trace parallel execution to provide information to Oracle customer support

Kursinhalt

  • Parallel execution concepts
  • Using Manual DOP
  • Using Auto DOP
  • Using Statement Queuing
  • In-Memory Parallel Execution
  • Parallel Execution and Data Loading
  • Troubleshoot situations when parallel processing does not proceed as desired
  • Managing a Mixed Workload with DBRM
Classroom Training
Modality: C

Dauer 1 Tag

Preis (exkl. MwSt.)
  • Deutschland: 670,- €
  • Schweiz: 670,- €
inkl. Verpflegung
Verpflegung umfasst:

  • Kaffee, Tee, Saft, Wasser, Cola
  • Gebäck und Süßigkeiten
  • Frisches Obst
  • Mittagessen in einem der naheliegenden Restaurants

Gilt nur bei Durchführung durch Fast Lane. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.


Termine und Buchen
Online Training
Modality: U

Dauer 1 Tag

Preis (exkl. MwSt.)
  • Deutschland: 631,- €
Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Deutschland
16.04.2019 München
 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.