Archive for July 2011

Oracle Technology Network South America Tour- Sao Paulo   2 comments

Being inivted by Oracle Technology Network (OTN),  on July 15th, 2011, I joined the last part of  OTN South America Tour to travel to Sao Paulo Brazil;  Montevideo Uruguay; and Santiago, Chile.  I will give two presentations at each conference.  On July  16th, I gave two presentations in Sao Paulo for the Brazil  Oracle User group  at GUOB) Tech Day 2011:

1) Virtualized Oracle 11g/R2 RAC Database on Oracle VM: Methods/Tips

2)Oracle 11gR2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting.

The followings are some photos from the conference and my presentation sessions:

This slideshow requires JavaScript.

Advertisements

1-Day Expert Oracle-Centric Conference at Massachusetts Institute of Technology (MIT) – VirtaThon Road Tour @BrainSurface   Leave a comment

BrainSurface The Collaborative ConnectSpace for Oracle, Java & MySQL Professionals proudly presents the 1st-stop in the VirtaThon Road Tour program; a 1-day Oracle-Centric Conference at the Massachusetts Institute of Technology (MIT) on 07/07/201. Join the experts and Learn4FREE for a full day of knowledge-filled sessions.

 
My session will be at 07/07/2011, 5:00pm – 5:45pm EDT

My presentation title is :
Case Study: Implementing Oracle Grid : Customer Case Study

Event attendance URL: https://www3.gotomeeting.com/register/274820990

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 dot.com 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. www.dell.com/oracle 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.