ºÝºÝߣshows by User: lumingdaa / http://www.slideshare.net/images/logo.gif ºÝºÝߣshows by User: lumingdaa / Mon, 30 Oct 2017 05:34:52 GMT ºÝºÝߣShare feed for ºÝºÝߣshows by User: lumingdaa [HKOUG] Oracle RWP - Developing High-Performance Systems by Christine Qu and Sidney Chen /slideshow/hkoug-oracle-rwp-developing-highperformance-systems/81357585 20171025oraclerwphkoug-171030053452
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.]]>
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.]]> Mon, 30 Oct 2017 05:34:52 GMT /slideshow/hkoug-oracle-rwp-developing-highperformance-systems/81357585 lumingdaa@slideshare.net(lumingdaa) [HKOUG] Oracle RWP - Developing High-Performance Systems by Christine Qu and Sidney Chen lumingdaa 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. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/20171025oraclerwphkoug-171030053452-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> 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.
[HKOUG] Oracle RWP - Developing High-Performance Systems by Christine Qu and Sidney Chen from Mingda Lu
]]> 139 1 https://cdn.slidesharecdn.com/ss_thumbnails/20171025oraclerwphkoug-171030053452-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 https://cdn.slidesharecdn.com/profile-photo-lumingdaa-48x48.jpg?cb=1615161949 Passionate about DB technologies, devops and enterprise HA / Hybrid Cloud architecture.