Managing complex Oracle database environments often presents many challenges to the database administrators in the area of database performance, backup and recovery, disaster recovery, data growth, and development and testing. This session introduces common technologies offered by many disk storage subsystems. It examines how DBAs can combine Oracle features such as Automatic Storage Management and…

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…

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

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…

Oracle Database security checklists and standards are focused on one database, not 1,000 databases. The significant challenge is when you have 100, 500, 1,000, or even 10,000 Oracle Databases in your organization to protect. In order to protect and securely maintain a thousand Oracle Databases requires an enterprise database security framework and database security program.…

The design of streams replication involves a pipeline of components that are responsible for capturing, propagating, and applying logical change records (LCRs) from a source database to a destination database. Because of the interaction between streams and the database, there are a number of areas that can suffer performance problems thus obstructing real-time data updates.…