Oracle Database 12c R1 R2 New Tuning Features
January 22nd, 2018
Viscosity invites you to join us for this informative Webinar!
Oracle ACE Director and Viscosity North America Chief Innovation Officer, Rich Niemiec, will be presenting the topics below:
This two part session will look at which 12c R1 & R2 new tuning features should be investigated for use. Most of the features that will be covered will be related to the DBA & Developer and 12c R1 & R2, but there will also many outside that realm (such as a list of 18c features at the end of part 1) and a short focus on the cloud pluses and minuses. There will be simple examples (such as a quick example using pluggable databases) to show the basic functionality of the new features:
Rich Niemiec’s best New Tuning Features:
- Using Memory Target and the Buffer Cache
- Multiple indexes on the same Column
- Fetch First x Rows
- In-Memory Virtual Columns
- Adaptive Execution Plans & Patch to fix issues
- Runaway query Management
- Online Move Partition and R2 Online Features for Partitions
- Partial Indexes for Partitioned Table
- Pluggable Databases (Includes Flashback PDB)
- Approximate Query new 12c R1 & R2 Features
- Quick In-Memory Tips with R1 & R2 New Features like In-Memory Joins
- Security Enhancements
- Exadata Advantages (Brief)
- V$ views
- Oracle in the Cloud
- 18c New Features to look forward to and the future ahead
Chief Innovation Officer, Viscosity
Rich Niemiec is the current Chief Innovation Officer of Viscosity North America. Rich is an Oracle Ace Director, a world renowned IT Expert, and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT.
Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich has architected and tuned many Fortune 500 systems over the past 25 years.
Chief Technology Officer, Viscosity
Nitin Vengurlekar is the co-founder and CTO of Viscosity North America. At Viscosity, Nitin is responsible for Service delivery, Partner relationship and end-2-end solution architecture. Nitin’s main emphasis has been on virtualization, Oracle Engineered Systems, Hyper-Converged Systems, and Public/Private Database Cloud implementations.
Nitin is a well-known Oracle technologist and speaker in the areas of Oracle Storage, high availability, Oracle RAC, and private database cloud. He is the author of Database Cloud Storage, Oracle Automatic Storage Management, and the Data Guard Handbook. He has also written many papers on storage, database internals, database tuning, and served as a contributor to Oracle documentation as well as Oracle education material.
Charles Kim is an Oracle ACE Director, Oracle Certified DBA, a Certified RAC Expert and Certified Exadata Implementation Specialist. Charles is also a VMware vExpert and a VMware Certified Professional. Charles specializes in RAC, Exadata, Virtualization and authored 8 books.
Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 25 years of Oracle experience on mission and business critical databases. Charles presents regularly at local, regional, national, and international Oracle conferences including IOUG Collaborate, VMware World, and Oracle OpenWorld on topics of RAC, ASM, Linux Best Practices, Data Guard Best Practices, VMware virtualization, Oracle VMware virtualization, and 7×24 High Availability Considerations.