My Presentations at Germany Oracle User Group Conference (DOAG2019)   Leave a comment

Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019):

Cloning Oracle EBS Database With Snapshot for DEV/Test

Abstract: For many complex database applications such as Oracle E-Business suite, it is quite common that a production environment needs 10 or more copies of various development and test purposes. This database clone process to create these many copies of production database can be very challenging and costly especially when the database gets larger than multiple even over 10 terabytes (TBs). This session will discuss two snapshot based methods that can help IT simplify this database cloning process and reduce the time and resource cost: The method is called Oracle gDBClone which is based on Oracle ACFS snapshot. The second method is based on database storage volume snapshot provided by the storage array. With a real example in our IT department, we will discuss the implementation details of these two methods and discuss the pros and cons of these two methods.

Oracle ADW for Advanced Analytic and Machine Learning

Abstract: Oracle Autonomous Data Warehouse (ADW) provides a fully automated data warehouse specific features to deliver outstanding query performance. As a fully managed cloud service running on high performance Oracle Infrastructure Cloud (OCI), ADW also comes with a new set of tools such as Zeppelin-based SQL notebooks for advanced analytics and Oracle machine learning. This session will examine the architecture of Oracle ADW and its collaborative environment. Then we will discuss how application developers and data scientists can leverage this environment: how import and export large set of data to/from ADW database instance, and how to build, evaluate, and apply machine learning models with SQL notebooks. With several examples, I will share some troubleshooting experiences and tips of building such advanced analytics and Oracle machine learning applications in Oracle ADW.

The  presentation slide deck links have been listed on the presentations section of this blog.

My Presentation Topic at Oracle OpenWorld 2019   Leave a comment

I will be speaking at Oracle OpenWorld 2019. Here are information of my session. Look forward to seeing and discussing this interesting topic with friends and colleagues in Oracle community.

Title: Achieving Massive Scalability and Total Fault Isolation with Oracle Sharding 19c.  Session Code: BUS1988

Session time and location: Tuesday, September 17, 04:15 PM – 05:00 PM | Moscone West – Room 3020A

Session abstract:

Oracle Sharding was introduced in Oracle Database 12cR2, and was further improved in Oracle database 18c and 19c for linear scalability and complete fault isolation for OLTP workloads. With Oracle Sharding, data is horizontally partitioned across discrete Oracle Databases (shards) that collectively form a single logical database. Come to this session to learn about the latest sharding improvements in Oracle Database 18c and 19c, sharding on Oracle Database Cloud, and leveraging sharding for your business. Hear about the experience of using Oracle Sharding in Dell IT’s global geo-distribution application, including what apps best fit to sharding, deployment of sharded databases with replication for massive scalability, and complete fault isolation. Lessons learned are also covered.

Session link at Oracle OpenWorld conference  catalog: https://events.rainfocus.com/widget/oracle/oow19/catalogow19?search=BUS1988

Posted August 23, 2019 by kyuoracleblog in Uncategorized

I will be speaking at Ohio Oracle Users Group Meeting   Leave a comment

I  will be invited as a guest speaker to present at the upcoming Ohio Oracle Users Groups meeting on March 24, 2017.

At the meeting I will be speaking at the following presentation sessions

10:00 – 11:00 A.M:   Oracle DBAs, let’s have a taste of Oracle Database Cloud Service
11:00 – 12:00 A.M:  Leveraging Oracle Database In-Memory to accelerate Business Analytic Applications
01:00 – 02:00 P.M:  Optimize Oracle Database Storage with Storage Tiering
02:00 – 03:00 P.M:   Oracle ASM Cluster File System for Private Cloud storage

For the details about the meeting , please refer to the Ohio Oracle Users Group link: http://www.ooug.org/

 

Posted March 21, 2017 by kyuoracleblog in Uncategorized

IOUG Oracle Database 12c R2 Expert Panel tomorrow December 6, 2016, 12:00pm – 1:00pm Central   Leave a comment

I will join three other Oracle ACE/ACE Directors Jim Czuprynski, Anuj Mohan, and  Rich Niemiec to present IOUG Oracle Database 12cR2 Expert Panel. We will share our experience of attending a week long  Oracle 12cR2 beta program on behalf of IOUG  in Oracle Lab at Oracle HQ. We  will also discuss some of the major Oracle database features introduced in Oracle 12cR2 such as those in Multitenant database, Database In-Memory, Oracle Sharding and many more. To attend this IOUG webinar, please get the registration information from this link:
http://www.ioug.org/page/oracle-webcasts-online-events

 

 

Thanks IOUG for Accepting My Presentations for Collaborate 17   Leave a comment

Just received a great news from IOUG that three of my presentations were accepted for Collaborate 17.

. Session #724:  Oracle DBAs, It is time to have a first taste of Oracle Database Cloud Service

    Abstract: As an important part of Oracle Cloud offering, Oracle Database Cloud service provides an easy of use enterprise-proven highly available and scalable database service. Oracle database cloud service can be the first “going to Cloud” that you, an Oracle DBA may experience. This session helps you get the first taste of Oracle Database Cloud service. It will examine choices of of database cloud services and help you to determine which one would fit in your business requirement. It will also discuss the technical expects of each of cloud services. Through a few examples, the session will discuss the DBA tasks and how you would perform in the new database environment ranging from creating database cloud service to managing the databases.

. Session #487, Leveraging Oracle Database In-Memory to accelerate Business Analytic Applications

Abstract :By introducing In-Memory column store, Oracle Database In-Memory (DBIM) significantly improves the performance for analytic queries as well as mixed workloads.  Come to this session to learn Oracle Database In Memory under the hood:  the dual format memory architecture and configuration, how the data is populated into In-Memory column store and  it helps query performance. . This presentation also covers further enhancements of DBIM in Oracle Database 12cR2  : Join group, and In-memory expression, In Memory active Data Guard support etc.   Through some case studies of business analytics projects, this presentation covers the practices of leveraging DBIM to improve the query performance of business analytic applications and how to use  In Memory advisor to determine the objects that need to be loaded into In memory column storage . We also will present some analysis on the performance gains by using IM memory features and when and how these gains can be achieved.

. Session #437: Get ready to upgrade your Oracle databases to 12c: tools, methods and paths

Abstract: In this session we will share some of our experience on upgrading different versions of Oracle databases to the  latest Oracle 12c. Attend this session you will learn the upgrade tools and various upgrade paths that help you plan your upcoming database upgrades. This will include upgrade methods for multitenant databases.  Another focus area of this session is Oracle RAC database upgrade which includes Oracle Grid Infrastructure upgrade and Oracle RAC database upgrade. You will also learn how to use the rolling upgrade for Oracle Clusterware and ASM and Oracle RAC database to reduce the database downtime.
And it will be my great honor to join my fellow Oracle ACE Directors and Oracle ACEs  as a co-speaker for their sessions:
. Session #779: Oracle VM, OEM13c and Cloud Computing – Expert Panel by   Tariq Farooq and Charles Kim and Kai Yu
. Session #518: Oracle 12c R2 Expert Panel by Anuj Mohan, Jim Czuprynski, Kai Yu, Seth Miller
And at last , but certainly not least,  I am waiting for  IOUG Collaborate 17 conference committee to accept one of important sessions in Cloud area:  the  IOUG Cloud SIG session: Session #711 Cloud Experience-To the Cloud and Back -Hands on Workshop by Steve Lemme, Charles Kim, Try Logon, Erik Benner, Kai Yu, Seth Miller.
See you at Collaborate 17@Vegas , next April!

 

Validated Infrastructure for Oracle Linux and Oracle VM   Leave a comment

If you are thinking about building  Oracle Linux or Oracle VM based systems for your Oracle databases, for example  building a private cloud type of system to consolidate your databases,. have you thought about the hardware  infrastructure  that your rest of platform will be built upon. One thing that you need to make sure is that the infrastructure stack is certified and validated for the software platform stack such as Oracle Linux/Oracle VM and the Oracle database.

The nice thing about this is that as a customer, you should not spend  your resources for this complex and time consuming certification and validation process  as various hardware vendors will partner with Oracle to establish the validated configurations. But you need to make sure that you select the proper infrastructure and OS  based on the validated configurations.  Since starting  working on Oracle Linux and Oracle VM in 2009 ,  it has been my team’s responsibility to work with Oracle Linux and Oracle VM team to certify  and validate  Infrastructure such as  Dell servers, storage and networking components  with Oracle VM and Oracle Linux Unbreakable Kernel (UEK). And we posted the validated configurations on Oracle Linux and Oracle VM  Validated Configuration (OVC) website : http://www.oracle.com/technetwork/topics/linux/validated-configurations-085828.html .

This website documented pre-tested , validated configurations and best practices of running Oracle Linux and Oracle VM on various infrastructure  such as Dell PowerEdge servers, Dell Storage and Network. With each of the validated configuration, customers  can run their  production Oracle database either with  Oracle Linux or Oracle VM as a  database platform.

You can get a completed list of the configurations with this link: http://linux.oracle.com/pls/apex/f?p=102:1. On this link, you can type a Hardware vendor name and you can get a list of the validated configuration with various hardware. For example,. if you  type Dell to search, it will come back with  55 configurations as today (10/19/2016). The list consists of the latest servers such as Dell PowerEdge R930 and various Dell Storages.

dell_ovc_list

This is what a specific configuration looks like:

dell_ovc_list_1

dell_ovc_list_2

OOW2016 Part 2: What I presented and what I learned   Leave a comment

Working in Progress, will come up in 2-3 days

Posted October 4, 2016 by kyuoracleblog in Uncategorized