This session reviews what the RAC Attack initiative is, and prepares attendees to install Oracle RAC 12c on a laptop for hands-on training purposes. At the end of this session you will be able set up a RAC sand box environment in no time using all Oracle tools: VirtualBox, Enterprise Linux and Database 12c. PowerPoint

RAC 11gR2 allows Database Administrators to push around users, patch like magic, and so much more, but I find DBAs are intimidated by it. This will present 5 tips to help demystify RAC by learning from mistakes before you make them, how services are beautiful, and why RAC has empowered me to be a great…

Original Broadcast: 2.6.14 In this educational session, Dell Software’s Oracle® replication expert, Sujith Kumar, illustrates how you can attain the five sigma’s of high availability using active-active replication in a critical database environment. Sujith will discuss replication techniques that can be easily incorporated into any database environment to prevent or eliminate downtime. You’ll learn simple…

It is impossible to think of PL/SQL without also thinking about SQL operations because the main purpose of PL/SQL is to provide the fastest and most efficient way of extending the relational database environment into the realm of procedural logic. The most important thing to remember is that SQL and PL/SQL are completely separate languages, each with its own strengths and weaknesses. SQL and PL/SQL have different memory structures, optimization mechanisms, etc. The critical difference between them is that PL/SQL is a procedural language, whereas SQL is a declarative, set-based language. This fundamental difference between the two languages means that you cannot effectively utilize SQL and PL/SQL together unless you stop thinking exclusively in terms “line-by-line” and “row-by-row”.

The first PL/SQL code elements to review when deciding how to properly use SQL inside of PL/SQL are cursors. The battle between proponents of implicit vs. explicit cursors is as old as Oracle databases. Sadly, online fighters often miss the key feature of database cursors, namely that they are nothing more than pointers to SQL…

A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing Oracle/MySQL databases with a heavy emphasis on VMware. In…

This presentation will look at which new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases)…

IOUG Oracle EM SIG Techcast: Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware Original Broadcast: 1.28.14 Oracle Enterprise Manager Cloud Control 12c provides a complete monitoring framework for applications, middleware, and infrastructure. Configuring it for high availability is recommended to ensure continuous monitoring. A level-2 HA configuration provides this ability while reducing costs.…

Original Broadcast: 1.23.2014 When it comes to making critical changes in your environment, or managing versions, you need to know you have complete control before something goes wrong. Luckily, Stat lets you breathe easy. In this webcast, you’ll discover how Stat 5.7.0 offers an improved migration console that puts all critical information about your deployments…

Original Broadcast: 1.21.2014 Alarm SMS messages and emails are being sent by the performance monitoring system to the production DBA team and the development team alerting everyone that the latest release of a critical business application and the underlying databases are grinding to a halt. • The developers, QA team, and DBAs all point fingers…