Presentation Title: Parallel Execution With Oracle Database 12c
Speaker: Mr Ivica Arsov ACE
Company: Pythian
Presentation abstract: In this masterclass, you will learn about parallel processing, an opportunity to extend your know-how in Oracle Parallel Execution. We will first start with the parallel execution concepts, why do we need it and get understanding where we can benefit from parallel processing. Once we cover the architecture and build a solid ground we dive into more details. Some of the topics we will cover are understanding producer/consumer model, using manual degree of parallelism, reading parallel execution plans, monitoring parallel execution, understanding row distribution methods, understanding blocking and non-blocking operations, understanding different statement types (DML, DDL, QUERY) that can be parallelized, what are the common misconceptions when executing parallel DML and DDL etc. We will discuss what are the common issues with manual parallel execution and how does Auto DOP solves them. We will cover row distribution methods focusing on HASH, BROADCAST and RANGE distribution methods and
Presentation begins: 04/12/2017 11:35
Presentation duration: 110
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: All Experience Levels
Audience function: Oracle
Speaker biography:  Ivica is an Oracle Certified Master 12c and 11g, and a recognized member of the Oracle ACE Program as an Oracle ACE Associate. He is a blogger and active contributor to the Oracle community and presents at many technology conferences. Known for his deep Oracle expertise and ability to troubleshoot quickly and efficiently, Ivica has the skills to solve problems quickly regardless of size and complexity. He is passionate about database performance and stability.
Related topics: Database: 12c Database, Database: Management & Administration, Database: Performance & Internals
Hall: Hall 5

ParallelExecutionWithOracleDatabase12c.pdf7.5 MB08/12/2017 12:55:46