Tag: Database

In Larry Ellison’s keynote  at Oracle OpenWorld 2015 he said, “We are in the middle, and I really do mean in the middle, of a generation shift in computing that is no less important than our shift to personal computing, when mainframes and minicomputers dominated our industry.” After this session attendees will have a better…

Security breaches, we have all heard they happen and how they can affect an organization and how expensive it can be when they do happen not to mention reputation damage.  Well know security breach happened from DBA credential being comprimized.  What can we do, what options do we have?  This presentation will start with the…

Since it was introduced in Oracle 12c, the new exciting Multitenant architecture makes the Oracle DBA's life much easier in terms of Administration and Management. In this session we will first review the 12c new multitenant architecture and then we'll review some tools and best practices which will help you consolidate your databases and also ensuring…

On version 12c Oracle introduced several new features to allow Adaptive optimizations: Adaptive Plans and Adaptive Statistics. After a quick presentation of concepts, this session will explore the interaction of these features with other performance management techniques using examples, like SPM and SQL profiles. Attendees will get an updated picture of tools available to troubleshoot…

Learn how the Oracle cloud can be used to backup and recover databases using RMAN, the defacto standard for Oracle backups. Learn how this solves the backup problem for both smaller IT organizations and larger Enterprises that use systems (like the ODA) that are deployed to remote locations. In this Hands on Lab, you will…

Big Data integration is an excellent feature in the Oracle Data Integration product suite (Oracle Data Integrator, GoldenGate, & Enterprise Data Quality). But not all analytics require big data technologies, such as labor cost, revenue, or expense reporting. Ralph Kimball, an original architect of the dimensional model in data warehousing, spent much of his career working to build an enterprise data warehouse methodology that can meet these reporting needs. His book, "The Data Warehouse ETL Toolkit", is a guide for many ETL developers. This session will walk you through his ETL Subsystem categories; Extracting, Cleaning & Conforming, Delivering, and Managing, describing how the Oracle Data Integration products are perfectly suited for the Kimball approach.

The presentation will tell about data migration from 10g RAC Solaris sparc to 12c RAC Linux 64x86 . The learner will hear about problems related to cross paltfrm and cross version migrations and complications related to the maintenance.  From other side the presentation will show how the much bigger volume of data was moved with…

As the Oracle Database evolves, so should the way DBAs monitor and manage it.  And even though the Oracle Database Scheduler was introduced with Oracle 10g over a dozen years ago, almost all DBA environments still rely heavily on the Linux (UNIX) CRON for scheduling of database monitoring, managment, or backup jobs. But the Oracle…

Regardless of whether you have Oracle Database Standard Edition, Enterprise Edition, or any optional packs there is a wide variety of key database security features and mechanisms built right into the Oracle database that are typically overlooked, under appreciated, not understood, or are unknown even to the experienced senior DBA. This presentation goes well beyond…

Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s. Eligible for Certificate: #IOUGeniusCert; #IOUGenius12c Info: www.collaborate.ioug.org/certificates