New from HKOUG

October 25th Meetup – Oracle Real World Performance – Developing High-Performance Systems (completed)

When : Wednesday, October 25, 2017 ( 2:30 PM to 5:30 PM )
Where : 3/F Auditorium, Li & Fung Trading Ltd

Spinners Industrial Building, 601-603 Tai Nan West St, Lai Chi Kok, Hong Kong (map)

Please register, as I need to give list of attendees to building security

Christine Qu & Sidney Chen from the Oracle Real World Performance Group will be joining us for a special event.

The Real-World Performance (RWP) Group is part of the Oracle Database Development organization. Engineers in the RWP group focus on extracting the maximum performance from the Oracle Database and hardware in the real-world. They do this by identifying inefficiencies in current systems and applying modern database design and tuning techniques.

To get more of an idea about what they are about, check out their YouTube Channel:

Sidney will be providing two sessions for us, see the abstracts below for more information:

How to Develop High-Performance OLTP system on Oracle

Summary: In the presentation we’ll use live demo to build a critical OLTP system, we’ll use 4 different approaches to implements the same system. The performance different between different approaches is over 100X times.

During this interactive session, we will work together to identify inefficiencies and improve the system performance, base on the data from ASH and performance views. We’ll show various code technique which cause huge performance difference, and how to avoid common development error, some error might be very hard to debug and might bring down the OLTP system.

How to Develop High-Performance ETL and DW system on Oracle

Summary: In the presentation we’ll use live demo to show the modern way to process large data set, by using Oracle set-based technique. We’ll build up an ETL system to process hundreds of million rows. We’ll have 4 racers which cost the hardware resource and software license, each with different technique:

1. Legacy row-by-row (aka, slow by slow)
2. Array interface
3. Home-grow parallelism
4. Native set-based technique.

The ETL process includes data loading, de-duplication, data transformation and analytical query. In this interactive session, the audience will learn there are orders of magnitude performance gain, by using set-base technique like direct path loading, parallel execution, window function and outer join.