This session will help attendees understand what is required to meet the needs of business in this everchanging environment. We must evolve our current data solutions to support better and more robust knowledge management. This session will help people understand how an organization can evolve their data warehouse and reportinging solutions to ones which are…

There is a strong perception among ORACLE DBAs that Hadoop is a "thing" for developers. One can't use it effectively, unless he or she is is a decent Java programmer, able to write sophisticated MapReduce jobs. Nothing can be further from the truth! Hadoop is all about managing data, so, of course, it still needs…

Cloud-based relational databases provide advanced features and architectures that enable high availability, backup and restore, and many other features for Oracle Database workloads. In this session learn best practices for using the features of a cloud-based RDS in a variety of single- and multiinstance topologies, and backup/restore using snapshots. This session teaches you to take…

The benefits of knowing your data before embarking on a BI or big data project are endless. Sure you can buy a tool to help with this. Or you could use R, an open source tool. This session will dig into methods for using R to connect to your data source to see visual and…

An Oracle User Community Cloud SIG workshop for Oracle Technology Professionals to obtain Cloud experience using Oracle Public Cloud and Oracle Technology on-premise together using their own laptop/device to accomplish work essential for their businesses & careers. Attendees learn how to setup OS secure authentication, generate a key, create a storage container to use the…

Oracle Database In-Memory introduces a new in-memory columnar format and a new set of SQL execution optimizations such as SIMD processing, column elimination, storage indexes, and in-memory aggregation, all of which are designed specifically for the new columnar format. This hands-on lab provides a step-by-step guide on how to get started with Oracle Database In-Memory…

No matter what other Oracle or 3rd party database tools Oracle DBA's and developers might embrace, SQL*Plus remains a mainstay. However many don't fully realize it's true efficiency potential by not mastering advanced techniques such as Dynamic SQL Scripting (i.e. scripts to generate and run scripts). Oracle ACE Bert Scalzo will demonstrate such techniques and…

In previous Oracle versions there were many different ways to setup auditing and separate auditing trails for components. There were also various layouts to the information provided within those audit trails. Oracle 12c introduces a new auditing framework where all auditing is written to a single repository and accessed by a single view. This framework is more secure and provides audit data in a single format. This option comes standard with Oracle Enterprise Edition, requires no additional license and is installed by default.

The new framework also allows you capture application context values and audit records from other sources such as:

• Oracle Database Real Application Security
• RMAN
• Oracle Database Vault
• Oracle Label Security
• Oracle Data Mining
• Oracle Data Pump
• Oracle SQL*Loader Direct Load
• Consolidating all these audit records into a single unified audit trail table.

The goal of this session is to briefly highlight the benefits of moving to the Unified Audit Trail (UAT) and provide a real-life example of steps taken to move from auditing as it was in pre-12c database versions to the Pure Mode unified auditing. We will review the default mixed-mode and the pure mode auditing, as well as the considerations and steps in switching modes. The major portion of this session will be on setting up managing audit records in the new framework and steps to assure you capture at least the same type of records as in your pre-12c environment.  The final part of the session will show how to setup policies for other resources utilizing RMAN and Data Pump examples.

Virtualization is already so 5-minutes ago. The cloud IT era is upon us. With more and more new, emerging and established software components and infrastructure pieces coming into the picture, how do you deal with those changes in Enterprise Manager? How do you prepare your current Enterprise Manager setup to continue providing the monitoring and…

As DBA's, we leverage OEM because it's the best platform for managing and monitoring the Oracle stack.   Business management typically knows about OEM because when there is an issue, DBAs use OEM to determine root cause and work with the business to fix the issue.While business management knows that DBAs use OEM for day-to-day…