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…

Behind the scenes, Oracle APEX stores all types of different information about your applications and user access in metadata tables. This session will cover some of the wide and varied uses you can put that data to.

WikiLeaks has dramatically changed how organizations deal with data security. Without getting into the politics, this session will discuss how to mitigate data breaches in your APEX applications. It will follow your data through its “chain of custody”, and provide insights on securing it at each step. It will cover not only things to do…

What's the right solution for your content management needs − Oracle WebCenter Content or SharePoint or both. This presentation will try to provide an understanding of the strengths and weaknesses of these two competing but compatable content management solutions while presenting a business strategy to use both of them at the same time. See how…

Oracle 11g offers several methods for database duplication, including duplicating to the same server or duplicating to an alternate or development platform for use as development instance. This talk will provide a real-life step-by-step example of how I use Oracle Active Duplication in 11gR2 to duplicate or clone my production instance to a development instance…

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaScript!

Oracle recently acquired Fatwire, a Web Experience Management product, and renamed it WebCenter Sites. What does this mean for existing Site Studio customers? In this talk, we will give you a run-down on the similarities, differences, and new features that are available. We will also give guidance on how to migrate, or have two systems…

Program Global Area (PGA) resides in the process private memory of the server process. PGA_AGGREGATE_TARGET is used to control the sizing of workareas. Often improper setup and incomplete understanding of the inner working of PGA and the interconnectivity with OS settings leads to ORA-4030 errors, which are raised when memory or resources are requested from…

Oracle Enterprise Manager Cloud Control 12c has introduced many new features that cover many different areas. Some of the new features are especially useful for the database administrator, such as visualization of performance data using ASH. This and other features have improved the management capabilities of the DBA.
Several exercises provide the student with the skills necessary to identify and isolate performance problems.

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…