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…

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 into performance management techniques using instrumentation from Oracle Exadata storage servers, Oracle Enterprise Manager 12c’s Automatic Workload Respository and Active Session History features, and SQL monitoring.

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…

An introduction to Logminer, to acquaint DBAs that have never made use of its capabilities. An overview setting up the environment, searching strategies and a couple of cases where Logminer was the tool that saved the day. Demo as time permits. Whitepaper PowerPoint

Oracle Recovery Manager (Oracle RMAN) has evolved since being released in version 8i. With the newest version of Oracle 12c , RMAN has great new features that will allow you to reduce your down time in case of a disaster. In this session you will learn about the new features that were introduced in Oracle…

Oracle WebLogic Server 11g provides enterprise-class messaging through the use of JMS destinations, yet there are little known facts regarding their behavior that have huge implications on performance, availability, and runtime. Join us to learn of Harris Corporation’s extreme case of high-throughput and high contention within WebLogic JMS for the FAA’s Next Generation Air Transportation…

Oracle Database 12c brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session explains improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization,…