The goal of this presentation is to go beyond the basic features of Oracle’s Automatic Workload Repository (AWR) and SQL Plan Management (SPM) to avoid plan regression and learn to use these tools with new techniques. You will see ways to combine the information stored historically in AWR with the capabilities available with SPM to…

Ksplice, now available as part of Oracle Linux, updates the Linux operating system (OS) kernel, while it is running, without a reboot or any interruption. Only Oracle Linux offers this unique capability, making it possible for you to keep up with important Linux updates without burdening your team with the operational cost and disruption of…

Oracle Real Application Testing is a very useful tool introduced in Oracle Database 11g and further enhanced in Oracle Database 11g Release 2. This presentation discusses how Oracle Real Application Testing works by going under the covers and derives a set of best practices based on real life experience with this tool

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

Understanding the ‘TRUE’ High Availability (HA) requirements for the systems is the most critical component in providing and configuring the desired HA for the application. Business and IT must have a common understanding regarding the cost associated with the expected HA. The associated cost and the ‘TRUE’ HA requirements primarily drive the solution architecture and…

Understanding the ‘TRUE’ High Availability (HA) requirements for the systems is the most critical component in providing and configuring the desired HA for the application. Business and IT must have a common understanding regarding the cost associated with the expected HA. The associated cost and the ‘TRUE’ HA requirements primarily drive the solution architecture and…

Einstein defined insanity as doing the same thing over and over and expecting different results. With decades of combined experience in delivering WebCenter Content projects, we have consolidated and categorized approaches that work, and approaches that don’t. We’d like to share this list with you with the hope that it will help you avoid making…

Oracle Real Application Testing is a very useful tool introduced in Oracle Database 11g and further enhanced in Oracle Database 11g Release 2. This presentation discusses how Oracle Real Application Testing works by going under the covers and derives a set of best practices based on real life experience with this tool

Einstein defined insanity as doing the same thing over and over and expecting different results. With decades of combined experience in delivering WebCenter Content projects, we have consolidated and categorized approaches that work, and approaches that don’t. We’d like to share this list with you with the hope that it will help you avoid making…