Archive for August 2012

Optimizing OLTP Oracle Database Performance using Express Flash PCIe SSDs   2 comments

PCIe SSDs are built with SLC NAND flash and designed for applications that require low latency and high IOPs (IO Per Second) operations.  OLTP database workloads which require very low storage IO latency with many small random read/write IO operations are one the idea cases to use PCIe SSDs to ehnance the performance.

To understand how much PCIe SSDs can really improve OLTP database performance, I have conducted  several extensive performance studies on a single node Oracle 11g R2 database as well as a two node 11gR2 Oracle Real Application clusters (RAC) database running on Dell PowerEdge R720 servers with  Dell Express Flash PCIe SSDs on Oracle Enterprise Linux 6.2 platform. 

If you are interested in how much performance gains you can expect these PCIe SSDs and some of the best practices of optimizing Oracle database using PCIe SSDs , you can check out my blog post and a detailed whitepaper published on Dell TechCenter Blogs with the following link: 

http://en.community.dell.com/techcenter/b/techcenter/archive/2012/07/31/optimizing-oltp-oracle-database-performance-using-dell-express-flash-pcie-ssds.aspx

Virtualizing Oracle E-Business Suite through Oracle VM   1 comment

Oracle VM provides the server virtualization that not only enables high availability and scalability, also simplifies and standardizes the deployment for Oracle E-Business Suite.  To leverage Oracle VM, the existing Oracle E-Business systems on physical servers need to be migrated to the virtual machines  and a new development needs to start on the VMs.  With the support of Oracle engineers, I worked with John Tao from Dell IT Oracle Applications DBA team to design and implement the systematic method to virtualize Oracle Applications E-Business Suites by migrating them from physical servers to Oracle virtual machines, as shown in the following diagram:

This work also allows creating the virtual machines templates based on the customer specific Oracle E-Business systems (EBS) and using these virtual machine templates for deployment of new Oracle EBS . This deployment method replaces the traditional cloning-based Oracle EBS instance creation method with Oracle EBS VM template based deployment. This new deployment has significantly simplified and standardized Oracle Applications E-Business Suite deployment for customers saving them time and money as shown in the following figure:

This method was awarded the “2011 OAUG Innovator of Year Award” by Oracle Applications Users Group (OAUG). For the detailed of this method, refer to this whitepaper on this link:

https://kyuoracleblog.files.wordpress.com/2010/01/virtualizing_oracle-e-business-suite_on_ovm_kai_yu_wp.pdf

 

My Oracle OpenWorld 2012 Sessions   Leave a comment

Just received an email from the Oracle OpenWorld Content commitee about the schedule of my presentation sessions:

 

How to Manually Install Flash Player Plugin to see the Oracle Enterprise Manager Performance Page   12 comments

As a DBA, you may find the Performance page of Oracle Enterprise  Manager (11g and 12c) very useful. However when you click the Performance tab on the Oracle Enterprise Manager, you may find the scree like this:

One of the solution is to install the flash plugin manually. Here are the steps to  do it on Linux server (Redhat linux 5/6, Oracle Linux 5/6)

1. Download the following rpm :  flash-plugin-11.1.102.55-release.x86_64.rpm

2. As root user,  Install this rpm on the server  that runs the browser for Enterprise Manager console:

 rpm -ivh flash-plugin-11.1.102.55-release.x86_64.rpm.

3. Until this point, you may think you have already installed the Flash player Plugin. But not really, if you click the performance tab,you would  still be asked to install the flash plugin. why?

 4. The issue is that the blowser like  firefox still looks for the flash player plugin library libflashplayer.so in

 /usr/lib64/flash-plugin/ while the installation of flash-plugin-11.1.102.55-release.x86_64.rpm put the this library in /usr/lib/mozilla/plugins

So the solution is to put the softlink for it:

ln -s /usr/lib64/flash-plugin/libflashplayer.so /usr/lib/mozilla/plugins/libflashplayer.so

5. Now when you click the Performance tab, you are able to see the clear picture of the database performance page: