Over the past seven years we've seen what is clearly a 3rd era in database management as the relational database  hegemony has given way to a diverse set of alternatives including Hadoop, Spark, HBase, Cassandra and MongoDB, augmented by technologies such as Kafka, Drill and others.   But these next generation data platforms are mutating rapidly: we're on a journey - but…

This presentation will cover Oracle’s Acceleration and the Cycles of Innovation in the world.  We’ll then look at the current Big Data Revolution and some of the solutions out there, as well as Oracle’s Big Data Solution.  We will review the role that both Google and Facebook have played in the Big Data Ecosystem and…

Oracle Redaction and Transparent Data Encryption are the most advanced features available in Oracle12c to guarantee optimal database security and data protection, by utilizing a combination of encryption standards and data retrieval methods and policies beyond SQL execution, which enable specialized administrators to fully condition access to private information, using encryption, row-level with either role-driven or…

With each new release of Oracle, the optimizer undergoes changes usually for the better, but sometimes there are unexpected side effects as well. This presentation will explore all of the new optimizer features, adaptive plans/statistics, and the changes to SQL plan management. Several case studies will show how it works, so you can quickly take…

This presentation will look at which 12c 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…

This lecture presents a centralized, secure and high available LDAP based Oracle naming service solution we developed and implemented in one major Canadian Bank capital market devision. It goes in-depth on how to extend Oracle context in Microsoft Lightweight Directory Service (LDS), load Oracle TNS entries to AD LDS in batch, manage TNS entries in…

DBAs have had manual systems for migrating data between storage tiers for many years. But now, Oracle Database 12c and Oracle FS Flash Storage System provide powerful new techniques. This session compares and contrasts the Automatic Data Optimization (ADO) Heat Map and Oracle FS Flash Storage System Heat Map features, and details how and when…

The database is a slave to time. DB time, elapsed time, CPU time, latency. Mastering database time is a critical aspect of database tuning. This presentation will discuss what the different types of database time are, how they are related and how to conserve them. Eligible for Certificate: #IOUGeniusCert; #IOUGeniusPerf   Info: www.collaborate.ioug.org/certificates

In environments that continue to grow in complexity the new features in Oracle 12 enhance RMANs ability to backup databases and reduces the complexity of restores when multiple databases must be involved or only partial restores need to be completed. ​This session will focus on live demonstrations using Oracle Virtual Box on testing and showing…

The Oracle High Availability Architecture with Oracle 12c RAC as the main pillar emerged as the foundation for the Application Resiliency.  Business continuity, high availability, scalability, flexibility and the agility combined with easy management are the key benefits of the Oracle 12c RAC.  When combined with the HA components like Flashback features, Flex ASM, Transaction…