In special situations, the Oracle Database generates too many child cursors for particular SQL-IDs. This results in high CPU load on the DB server, coming from heavy mutex access. This is visible as mutex wait events. The lecture will show how this situation arises, how the DBA can try to quick-fix it and how long-term…

RAC and Clusterware are complex environments to administer and even more so when there are problems. Learn about various tools and utilities which can be used to troubleshoot, instrument and diagnose these problems.

IBM has had many successful implementations of Oracle database on Linux on z and this presentation will present the best practices learned from those prior successful engagements. The presentation will focus on: 1. Architecture of the virtualized environment including sizing 2. Discussion of guest layout including disk access 3. Currency of Oracle products on Linux…

The Automatic Workload Repository is a powerful feature that was introduced in Oracle 10g and improved in Oracle 11g. Learn how you can utilize that power at an Enterprise level by bringing your Automatic Workload Repository data together into a central repository to compare reports across databases in your Enterprise; keeping snapshot data for longer…

RAC and Clusterware are complex environments to administer and even more so when there are problems. Learn about various tools and utilities which can be used to troubleshoot, instrument and diagnose these problems.

Many of today’s application interfaces are Web-based and dynamic using the power of relational databases like Oracle and MySQL to provide “live” data on demand. This capability has made modern Web-based applications key to many business processes. But BEWARE; unwitting coding practices may lead to something called “SQL Injection” where someone taking advantage of poorly…

Find out how to control that unruly, unstructured content with metadata. Learn about topics such as metadata discovery, controlled vocabularies and parametric search. See how Oracle WebCenter Content can provide you with technologies and tools to implement these ideas.

We are alarmed by a recent trend back to the philosophy of closed, proprietary servers that was popular in the 1960s and all but dead by the mid-80s. The idea of open systems as an alternative to the proprietary mainframe was championed by Oracle, HP, DEC, and others in the 1980s, and the arguments in…

This seminar will teach you the beginnings of flashback. It will cover flashback from simple like flashback query to complex like flashback database.

This session will explain how to install and patch Oracle database software using Dual Oracle Homes. Dual Oracle Homes give you the flexibility to patch one Oracle Home while leaving the other at the current patch level. We will cover all the benefits of using Dual Oracle Homes and dive into how we implemented this…