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 solutions can be found.

Additionally, we will have a closer look on the Oracle internal situation: Why does the DB use mutexes here, and how?

Real Application Testing (RAT) with Database Replay and SQL Performance Analyzer has given us the ability to be more proactive in ensuring that application, database, operating system, hardware, etc. changes and upgrades never negatively impact our database and system operations again. This presentation will review the features and use of real application testing with Test…

Oracle VM Server for x86 is Oracle’s virtualization product for the commodity hardware platform. This product is the only virtualization product supported by Oracle for database virtualization. Edward Whalen is the author of the newly published book “Oracle VM Implementation and Administration” from Oracle Press. In this session he will cover an introduction to the…

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…

Would you like to gain insight into your workflows in WebCenter Content? Come learn how a custom component was designed and built to report on WebCenter Content workflow history in a configurable fashion at Emerson. We will discuss architecture, features, hurdles, limitations, and the final outcome; including a demonstration of the final product.

For over 10 years, since its introduction in Oracle8, partitioning has been a very powerful tool for management and performance of Oracle databases. Each major release since that time has added additional capabilities and Oracle Database 11g is no exception. Several powerful options are now available which allow for almost unlimited flexibility in building and managing partitioning. This presentation will discuss the new partitioning features introduced in Oracle Database 11g including interval, virtual column, reference, and system partitioning, and a range of additional composite partitioning options. Included will be a discussion of enhancements for single partition export and changes to the SQL Access Advisor. Examples will be shown along with usage recommendations for the new capabilities.

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…

Virtualization technology provides the solution to enable the server partition and consolidation for improving the resource utilization and archiving the great flexibility and high availability. Combining Oracle VM with Oracle RAC provides the Database Cloud ready architecture to consolidate the data center infrastructure. The new Oracle VM 3.0 release not only improved the scalability, but…

Recently released Oracle Enterprise Manager 12c Cloud Control provides a complete, out-of-the-box integrated solution for total private cloud management. This session will have a step-by-step walk-through for cloud and self-service administrators who are setting up a private cloud based on Oracle VM 3.0 provide infrastructure as a service (IaaS) and platform as a service (PaaS).…

With the acquisition of Hyperion by Oracle and the integration of the Enterprise Performance suite in the Oracle stack, it is becoming more common to implement Hyperion Financial Management (HFM) and Hyperion Planning (HP) injunction with OBIEE and eBS. The need to work alongside with broader ERP and BI team has become paramount to successfully…