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:
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:
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-184.108.40.206-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-220.127.116.11-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-18.104.22.168-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: