Oracle’s AWR (Automated Workload Repository) provides a plethora of information for understanding what your database is doing during specific periods of time. The AWR consists of 111 DBA_HIST% views, 281 metrics, 652 statistics and a multitude of other interesting DB performance snippets that can be used to assemble a cohesive picture of the performance problems…

Oracle does a wonderful job of detecting and handling deadlocks generated by applications. But you still have to resubmit any changes rolled back in untangling the deadlock. Better performance can be achieved by avoiding deadlocks in the first place. Establishing an enterprise wide order of tables and row order within tables helps minimize deadlocks. This…

Don't you hate those days you come into work and a user walks up and says that the database is down? The normal response is "It's a network issue". That will at least buy you a little time while you start to figure out what's wrong. You would normally open a command line and start…

The new release of Oracle Database has come with many new exciting enhancements for the High Availability. The aim of this presentation is to introduce some new DataGuard features through practical examples. Among various enhancements, special attention will be given to the new Far Sync Instance and the Real-Time Cascade Standby. Whitepaper PowerPoint

Today, many businesses around the world are using an Oracle product and in many of these at the core there is an Oracle Database. Many of us who started as a Database administrator where put in this position because we were good PL/SQL programmers or good Sysadmins, but knew very little of what it took…

Today, many businesses around the world are using an Oracle product and in many of these at the core there is an Oracle Database. Many of us who started as a Database administrator where put in this position because we were good PL/SQL programmers or good Sysadmins, but knew very little of what it took…

Today, many businesses around the world are using an Oracle product and in many of these at the core there is an Oracle Database. Many of us who started as a Database administrator where put in this position because we were good PL/SQL programmers or good Sysadmins, but knew very little of what it took…

Oracle Enterprise Manager 12c enables complete management of Oracle Exadata, including management of the storage servers, the InfiniBand fabric, and Oracle Database and its Oracle Grid Infrastructure feature. This session presents an overview of how you can utilize Oracle Enterprise Manager Cloud Control to effectively monitor and manage Oracle Exadata, followed by a deep dive…

All of the various storage vendors quote IOPS ratings for their equipment, but when you read the fine print, a lot of details are involved in actually achieving those numbers. With multiple layers of storage/network/operating system/database software/hardware/drivers in play, it is practically impossible to deploy the vendors' reference configuration into your production environment. This being…

All of the various storage vendors quote IOPS ratings for their equipment, but when you read the fine print, a lot of details are involved in actually achieving those numbers. With multiple layers of storage/network/operating system/database software/hardware/drivers in play, it is practically impossible to deploy the vendors' reference configuration into your production environment. This being…