Archive for the ‘Database flash cache’ Category

My Oracle OpenWorld 2013 Schedule   Leave a comment


The Oracle OpenWorld 2013 will be held from Sunday September 22 to Thursday September 26. This is my 8th year Oracle OpenWorld experience. Since Oracle OpenWorld 2006, I have given total 16 Oracle OpenWorld presentations in the last 7 Oracle OpenWorld conferences. As usually this year my Oracle OpenWorld participation will start with two days Oracle ACE director Oracle product briefing in Oracle Cooperation Headquarter in Redwood shore on Thursday and Friday . After having a Saturday break, I will start my Oracle OpenWorld 2013 journey which includes six presentation/panel sessions and many meetings and networking activities. The most importantly I will have chances to meet many friends in Oracle community from different parts of the world. Here I list the six sessions that I will present or participate. It is my honor to have the opportunity to co-present these sessions with the great speakers from the Oracle community. And I look forward to having great discussions with those who are interested in the related topics:

1.  Clustering/High Availability with Oracle VM and Oracle Enterprise Manager 12c: 360 Degrees [UGF9803]
Speakers :
Tariq Farooq , Kai Yu
Sunday, Sep 22, 1:00 PM – 2:00 PM – Moscone West – 3016

2. Oracle VM and Virtualization Best Practices: Expert Panel Discussion [UGF9809]
Speakers : Tariq Farooq , George Trujillo, Charles Kim , Kai Yu
Sunday, Sep 22, 3:30 PM – 4:30 PM – Moscone West – 3018

3. Extend Oracle Database Management with Quest Tools from Dell [CON11326]
Speakers: Guy Harrison, Steven Feuerstein, Kai Yu
Monday, Sep 23, 1:45 PM – 2:45 PM – Moscone South – 250

4. Best Practices for Deploying Highly Scalable Virtualized Oracle Applications [CON11257]
Speakers:Tariq Farooq , Kai Yu, AJ Schifano
Monday, Sep 23, 4:45 PM – 5:45 PM – Westin San Francisco – Concordia

5. Configuring Database Cloud with Oracle Database 12c on Dell Blades: Methods/Tips [CON11220]
Speakers: David Mar, Kai Yu
Monday, Sep 23, 3:15 PM – 4:15 PM – Moscone South – 250

6. Accelerating OLTP Databases with Flash-Based Storage: Case Studies [CON11235]  
Speakers: Naveen Iyengar, Kai Yu, Guy Harrison
Tuesday, Sep 24, 10:30 AM – 11:30 AM – Moscone South – 250

Besides of my presentations, I also plan to attend some technical sessions including some OakTableWorld sessions and technical deep dive sessions. I will have some meetings with Oracle engineers and product managers in Oracle virtualization, Oracle RAC and Oracle Linux .


2012 Kai Yu’s Oracle Activities Summary   4 comments

Today is the last day of year 2012 and maybe  be the best time to summarize my Oracle related activities in the year.

In 2012, I  have  focused on the following technologies:

  1. Optimizing Oracle database performance using Solid State Drive, specifically the PCIe Flash SSD.
  2. Oracle RAC on Oracle Linux 6.x and Red Hat Linux 6.x
  3. Oracle VM 3.11 and Oracle VM Manager 3.1.1
  4. Oracle Enterprise Manager 12c
  5. Oracle Infrastructure Cloud
  6. Oracle Virtual Assemblies and Oracle Virtual Assembly Builder.

As the result of the research and study on these areas, I wrote these five technical whitepapers:

1.  Optimizing OLTP Oracle Database Performance using Dell Express Flash PCIe SSDs, Dell TechCenter Blogs, July 31st, 2012

2. Virtualizing Oracle E-Business Suite  through  Oracle OVM , Modified version of the Original conference whitepaper Oracle E-Business Suite: migration to Oracle VM Template Based Deployment.

3.  Configuring and Managing a Private Cloud with Oracle Enterprise Manager 12c,  IOUG Collaborate 12 Conference whitepaper, April ,  2012.

4. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0: Methods/Tips, IOUG Collaborate 12 Conference whitepaper, April ,  2012.

5. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 2.2: Methods and Tips, published in IOUG SELECT Journal Q, 2012 issue.

And I also gave 16 technical presentations on several  technical conferences  including Collaborate 12 (C#12), Oracle OpenWorld 2012(OOW12), Oracle Technology Network Architect Day keynote , EMEA OUG Harmony 2012 , OAUG Connection Point®–Oracle E-Business Suite Release 12.1 and Fusuon applications in Austin, , OTN Expert+ Conference @NUCES/FAST, 2012 East Coast Oracle Users Group  Conference (ECO#12) , IOUG Virtualization SIG – Online Symposium

  1.  Enterprise Manager 12c Cloud Control: New Features and the Best Practices for Installation, Configuration and Upgrade of Enterprise Manager 12c, C#12,
  2. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0: Methods/Tips, C#12,
  3.  Alternative options to enhance the High Availability, session #840 (HA bootcamp), C#12,
  4. Configuring and Managing a Private Cloud with Oracle Enterprise Manager 12c, C#12
  5. High Availability Infrasturcture for Cloud Computing,  OTN ArchDay Keynote
  6. Oracle 11g R2 Clusterware: Architecture, Configuration, Troubleshooting,  EMEA#12, Finland, 
  7.  Oracle E-Business Suite: Migration to Oracle VM & template based deployment,   EMEA#12, Finland, .
  8.  Oracle E-Business Suite: Migration to Oracle VM & template based deployment,  EMEA#12,  Latvia. 
  9. Configuring and Managing a Private Cloud with Enterprise Manager 12c , IOUG Webinar
  10.  Oracle on Oracle VM: Expert Panel,  OOW12
  11. High-Availability Infrastructure of the Database Cloud: Architecture and Best Practices, OOW12
  12. Simplify App Deployment in the Cloud with Virtual Assemblies and Oracle Enterprise Manager 12c, OOW12
  13. Oracle VM &  Cloud Computing 360 Degrees,  OTN Expert+ Conference @NUCES/FAST
  14. Virtualizing Oracle E-Business Suite through Oracle VM,  ECO#12
  15. Simplifying Application Deployment in Cloud Using Virtual Assemblies and EM 12c, IOUG vSIG
  16. Oracle on Oracle VM – Expert Panel, IOUG vSIG

In last few months of the year, my focus has been on the new Apress Oracle book “ Expert Oracle RAC” which I co-author with three  industry well-known RAC experts and Oracle ACE directors: Syed Jaffar Hussain, Riyaj Shamsudeen  and Tariq Farooq . I have been working on  the contents including RAC architecture overview, Storage and ASM, Clusterware, Network,   Application Design Issues , Challenges in a Complex RAC Environment.

At Oracle OpenWorld 2012, I was granted the industry prestigious award: 2012 Oracle Excellence Award : Technologist of the Yeafor Cloud Architect by Oracle Magazine.   This award will be officially announced  on Oracle Magazine ‘s January/Feb 2013 issue.

My Interview with VirtaThon Internet Radio   Leave a comment

On June 20, 2011, I was interviwed by Mr. Tariq Farooq, the host of VirThron Internet Radio of BrainSurface . The interview was broastcasted live and recorded at the following link:

The followings are the text of the interview. (Any views or opinions presented in this interview are solely those of the author and do not necessarily represent those of my employer or other companies  or the interview host)

Oracle ACE Director Kai Yu’s Interview with VirtaThon Internet Radio on Wednesday, June 22, 2011

Host: Tell us about your early/college/academic life.

Kai: I got my Bachelors degree and Masters degree of Computer Science in China and also receievd my second Masters degree of CS in US.  My interest has always been  on database related fields.

Host:How you got involved/started with Oracle.

Kai: In the early days of my career, I did some application development work with C++ and Oracle Call Interface(OCI). Around 1995, I started working on PL/SQL and Oracle database management, and moved to a full time DBA role. In 1997, I started working on some advanced Oracle database features such as Oracle Parallel servers on Digital Alpha cluster, then moved to Oracle on Sun during the time around 1999. In 2002, I started focusing on Oracle on x86/Linux platforms.

Host: Tell us about your evangelist activities as an Oracle ACE Director and what it takes to become one.

Kai: My evangelist activities include presenting at Oracle conferences in US and worldwide and publishing Oracle whitepapers and involving Oracle community activities such as user groups and sharing my experience by maintaining my Oracle blog. Definitely these activities really help my Oracle career as I learned so much from the community. And when Oracle evaluates an Oracle ACE director application, they really look at what the evangelist activities this individual has done in the past and what he/she continually commit to do for the community going forward.

Host: Tell us about your experiences being an author/blogger/speaker.

Kai: I started presenting at Oracle OpenWorld(OOW) 2006 and continued every year and completed  total 9 OOW presentations so far  and have 4 accepted for OOW2011. And I also did 11 presentation at the Collaborate, a few other international presentations in UKOUG Tech and EBS conference,  Scotland OUG conference and OOW Asia conference.  It is great to be a part of the Virtathon virtual conference speaker team. Writing Oracle whitepapers is another area. So far I authored  17 whitepapers. One of my presentation/whitepaper won the 2011 OAUG Innovator of year award. The topic was about how to virtualize Oracle E-Business Suite on Oracle VM.   I also actively maintain my Oracle blog. Next month I will join in OTN Latin America Conference tour to Brazil, Uruguay and Chile. On the conference tour, I will give two presentations in each country: 1) Configuring Oracle RAC on Oracle VM, 2)Oracle  11g R2 RAC best practices. And we are planning to have an Asia and Pacific tour after Oracle OpenWorld conference in October.

Host: Tell us about your company and your role there.

Kai: I work in Dell Oracle Solutions engineering lab as a senior engineer and architect. We have a very strong engineering team that tasks to architect and validate various Oracle solutions on Dell platform. We provide customers the best practices and the validated Oracle solutons with the entire technology stack including servers, storage, network, Oracle software. We publish our  results and whitepapers online. is where our team is located.  My company really values my work by granting me two company-wide awards from  company executives in 2008 and 2011 respectively. Before joining this team in 2006, I had been in  the Global Database Management team at Dell for more than six years. My focus areas have been Oracle RAC, Database, Oracle VM, Enterprise Manager, Oracle E-Business suite Technology stack.

Host: What is your favorite Oracle 11gR2 Feature?

Kai: The two of my favorite Oracle 11g R2 features are: Edition Based Redefinition and Database flash cache.   Edition Based Redefinition allows you to upgrade the database components of an application while it is in use., This can  minimize or eliminate the database downtime.  With this feature, to upgrade an application , you make a copy the database objects of the application,  then  you make the change changes while application continues to run the unchanged components. After ensuring the change is connect, you make changes  available to all users. 

Database flash cache or called smart cache adds the another layer to the traditional Oracle database two layers storage: database buffer cache and the disk storage.  Flash cache feature provides a transparent extension of the database buffer cache using solid state device (SSD).  If you see the disk IO performance bottom neck in your database, such as a recommendation of increasing  size of the buffer cache, db file sequential read in a top wait event in AWR report, adding flash cache using SSD as the middle layer of storage can significantly reduce the physical disk IO and reduce database query response time.

It is easy to configure: add SSD storage as a device into the database server (single node or RAC node), and configure two init.ora parameter: db_flash_cache_file  point to the device name of the SSD storage, db_flash_cache_size indicates the size of the SSD device. With this configuration, this SSD flash cache will acts as a Level 2 cache to the (Level 1) SGA.

 We can use this feature generic X86 platform without Exadata with SSD storage such as Fusion-IO card  Our team had produce a very good study using the fusion IO card on x86 64 platform. You can visit our website to download the whitepaper.

Host: What would you anticipate/foresee/want in the next generation of Oracle Database Server family of products?

Kai: Today I can see the database technology is also moving with the rest of IT industry. I would expect two areas that the  database server  needs to add more work on: how the database provides a better platform (database as service) for the cloud infrasturecture. This may be related to the workload management, general database management and  how the database works on a virtualized environment. The second area is how the  database works with tiered storages. As we know due to the huge gap between CPU speed and the storage performance, most database performance bottlenecks are on the storage side. SSD technology or the tiered storage is a solution to solve this problem. Oracle Database should leverage the SSD technology or tiered storages to improve its performance.

Host: If you could change/improve one part of Oracle Database Server, what would it be?

Kai: Two areas I just mentioned certainly can improve the database server. Of course there are many other areas too,.

Host: What are your favorite tips/tricks/recommendations that you would want to share with the audience as far as Oracle Best Practices are concerned?

Kai: One of areas that I can provide is how to configure the network and shared storage on Oracle VM virtual machine to run Oracle RAC. To configure the private network for the RAC installation, Oracle recommends to bound two network interfaces together. In Oracle VM environment, guest VMs (dom U) don’t have the physical network interface, instead they have to rely on the network interfaces on the VM server (Dom 0). The way to configure this is to bound the two private network interfaces in the VM server first, for example bond eth2 and eth3 to form a bond1 logical network interface , then create a Xen bridge based on bond1. Then we can build the virtual network interface eth1 in the guest VM using the Xen bridge. We can do the same for the public network bonding. I have the details on my OOW presentation.  Go to my Oracle blog to find the related whitepaper and the conference presentation. 

Host: What advice do you have for our audience to stay in demand and ahead of the curve?

Kai: Today as the technology has progressed in such a fast pace, it is not easy to stay in demand and ahead of the curve. We have to put ourselves in learning mode all the time. It is not a very good idea to stay in your comfortable zone for too long. I have seen some companies or DBAs staying  the same system configuration for many years, not so good for the business and very bad for our technical career. The best learning opportunity is to implement the new features in your system. Other advice is to attend the industry conferences regular to get the updates on the technology, read other people blogs/OTN forms and use google  to search for answers. VirtaThon virtual conference is one of the great examples that enable your remote learning.

Host: Please tell us about VirtaThon and your role there?

VirtaThon is a virtual conference facility for Oracle, Java & MySQL communities. From here you can attend, participate & learn cutting edge knowledge from recognized domain experts from all over the world. When this idea was first implemented by our pioneer and leader Mr. Tariq Farooq, I was so amazed.  This virtual conference facility really helps us to learn new knowledge in a most convenient way. I was so fortunately to be invited to join the speaker team as well as the conference advisor committee , a sort of geeks team behind of the VirtaThon virtual conference facility.