Understanding the ‘TRUE’ High Availability (HA) requirements for the systems is the most critical component in providing and configuring the desired HA for the application. Business and IT must have a common understanding regarding the cost associated with the expected HA. The associated cost and the ‘TRU…

This is a two-part session that will take place on Monday and Tuesday. Database shrinking can be overwhelming. Don’t let this feature intimidate you; let it become a powerful friend! This session describes why shrinking is needed and just how to go about using it. Being forewarned and forearmed will decrease…

This presentation is a high-level introduction to Oracle RAC. Many RAC beginner presentations are given by seasoned RAC experts and contain an overwhelming suite of technical discussions, covering a way too much information for the level of expertise of most attendees. This presentation is given by…

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and s…

More and more companies are utilizing virtualization in their environments to lower costs and effectively utilize resources. Placing Oracle databases in virtualized environments is not just for development and testing anymore. The rise of virtualization is introducing new performance challenges to the Oracl…

Even the best-planned database upgrades can leave nagging questions: what happens if my upgraded system performs unexpectedly? Is there a way I can go back to the previous version without downtime and data loss? Oracle GoldenGate allows DBAs to give affirmative answers to these questions. Drawing o…

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 lo…

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 o…