Oracle 12cSIG Virtual Symposium 2017
May 3 @ 10:00 am - 3:30 pm
Keynote Presentation: What to Expect from Oracle Database 12c
Time: 10:00-11:00AM CST
Presenter: Maria Colgan
Databases are fundamentally changing due to new technologies and new requirements. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what’s new in Oracle Database 12c and Oracle’s engineered systems. Maria will describe which industry transformation inspired each enhancement and explain when and how you can embrace each enhancement while preserving your existing performance.
Session 1: Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS
Time: 11:00-12:00PM CST
Presenter: Jim Czuprynski
Originally introduced in Release 126.96.36.199, Database In-Memory (DBIM) offers the ability for analytic queries to sift through billions of rows at incredible speed because data is now retained in columnar format in the In-Memory Column Store (IMCS). Oracle Database 12cR2 dramatically expands the capabilities of DBIM, making it even simpler to implement, monitor, and manage while extending its reach to more complex execution plans, expanding its utility to Active Data Guard (ADG) instances, and enabling capture of frequently-evaluated expressions in the Expression Statistics Store (ESS).
Through presentations and examples using Swing bench’s latest TPC-DS query generation features, this session will illustrate how Oracle 12.2 Database In-Memory:
– Dramatically speeds execution of analytic queries through In-Memory Column Store (IMCS)
– improves the management and monitoring of the IMCS
– Improves complex query execution through improvements like Expressions Statistics Store, In-Memory Filtering, and Parallel Execution
Session 2: Oracle 12c R2 Multitenant: Key Feature Sets for Beginners to Experts
Time: 12:00-1:00PM CST
Preseneter: Anuj Mohan
Oracle Multitenant is a key feature when we are consolidating databases, offering a lot of benefits over pre12c consolidation options. In this session, Oracle ACE, Anuj Mohan will review Oracle multitenant options; including a brief introduction into CDBs and PDBs as well as an Explanation of Value (EOV). Anuj will then briefly discuss migration options to 12c from previous versions, and finally delve into some of the key new 12cR2 Multitenant features like PDB Hot Clone, Refreshable PDBs, PDB Relocate, Lockdown Profiles, Application Containers, SGA/PGA Limits for PDBs, and Memory I/O Resource prioritization.
Session 3: Oracle 12c R2 MAA: RAC/ASM/ACFS and Data Guard
Time: 1:00-2:00PM CST
Presenters: Charles Kim and Nitin Vengurlekar
Oracle RAC, ASM including ACFS, and Data Guard are core components of the Maximum Availability Architecture (MAA). New features released in Oracle 12c Release 2, are so vast that we can practically write a book on it. Charles Kim and Nitin Vengurlekar will reveal all the core new components associated with RAC/ASM/Data Guard. They will discuss how you can achieve higher level of availability and scalability. Beginning by discussing rapid home provisioning, streamlined GI installation, RAC reader nodes, load-aware resource placement for Oracle Grid Infrastructure and go deeper into additional functionality improvements. For ASM, they will discuss flex disk groups and file groups, IO Server, ACFS Snapshot Enhancements, and other subtle improvements. Last, they will go deep with Data Guard new features such as MIRA, no logging support, extended support for ADG, extended broker support, enhancements for PDBs and much more.
Session 4: Expert Panel Discussion
Presenters: Maria Colgan, Jim Czuprynski, Anuj Mohan, Charles Kim, and Nitin Vengurlekar
Our panel will turn its attention to any open questions asked during the virtual symposium, as well as talking about the future of 12cR2 Database. Stay around – it will be a lively discussion!