Arizona Oracle User Group Day

Thursday, January 25, 2019, 11:30 AM – 5:30 PM

Day(s)

Hour(s)

Minute(s)

Second(s)

Presentation Topics:

Top 18 Oracle Database 18c New Features

Oracle Database 18c was released in Oracle Cloud in February 2018. Oracle made the software available to on-premise customers in July 2018. Oracle Database 18c packs ton of new features for enterprise customers. Oracle continues to deliver new functionality that’s only available to their flagship product. Come see what makes Oracle Database 18c the leader in the magic quadrant. Learn why you should consider upgrading directly to Oracle Database 18c.

This presentation will look at which 18c 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. Viscosity has been actively involved in the Beta program over many versions of Oracle. Overview of new features include:

Multitenant Advancements
- PDB enhanced security
- PDB enhanced high availability
Zero Impact Grid Infrastructure Patching
Data Guard Enhancements
ASM and ACFS Enhancements
Private Temporary Tables
Scalable Sequences
New Installation Support
18cXE innovations
Docker Support

What’s New in Oracle Database 12c Release 2

Oracle continues to be the fastest, state-of-the-art, revolutionary database in the world. Companies can recognize immediate ROI by upgrading to Oracle Database 12c Release 2. Come learn what it takes to upgrade to Oracle Database 12c Release 2 and unleash the value of the new features to rapidly:

Achieve another level of data scalability and horizontal partitioning with Sharding
Attain higher levels of SLA with new features in Data Guard
Eliminate downtime with enhanced online features for table and index maintenance
Tackle Partitioning and Index advancements in 12.2
Secure your entire database with online encryption capabilities
Take advantage of Oracle 12cR2, object names for users, roles, tables, columns, indexes, constraints, etc., increase from 30 bytes to 128 bytes with a few limitations to easily migrate from other databases
Implement the new features in ASM
Integrate the new features in Oracle RAC
Utilize Information Lifecycle Management (ILM) features like Automatic Data Optimization (ADO) and Heat Maps work within individual PDBs for effective management of storage resources based on actual data usage patterns
Leverage all the latest features such as cloning and replication features for PDBs (Pluggable Databases) that enable the journey to a private, hybrid, or public cloud environment.
- With 12cR2, you can have hot-cloning (source no longer needs to be read-only), refresh clones, flashback PDB only, and build PDB-level standby plans
- Tightly control SGA, PGA, and I/O resources for individual PDBs, including how to construct standard PDB resource profiles that can be leveraged by multiple PDBs with similar resource demands
Scale performance exponentially with In-Memory (IM) Column store; in Oracle 12cR2 there are additional In-Memory enhancements (including IM Virtual Columns)
Leverage Approximate Query Functions for performance

For Oracle customers who are on Oracle version 12.1, they need to upgrade to Oracle version 12.2 by July 2019. For Oracle Database 11g Release 2 customers, you should already be on Oracle version 12.2 or even 18c. As you upgrade to Oracle Database 12c Release 2, learn how you can modernize your infrastructure on the latest Oracle Engineered systems with zero downtime and zero risk.



Arizona Oracle User Group Tech Day

Republic Services

14400 N 87th St. Scottsdales, Az. 85260

2nd Floor Conference Rooms

January 25, 2019, 11:30 PM – 4:30 PM Mountain Time Zone
(lunch provided by Viscosity)

Republic Services

Yes, I Want To Attend the Event!

Agenda

11:30 – 12:00 Registration

12:00 – 1:00 Lunch

12:30 – 2:00 Oracle Database 12.2 New Features

2:00 – 2:15 Break

2:15 – 3:45 Oracle Database 18c New Features

3:45 – 4:00 Q & A + prize drawings

About the Presenters

Charles Kim

President, Viscosity

Charles Kim is an Oracle ACE Director, a VMware vExpert, an Oracle Certified DBA, a Certified Exadata Implementation Specialist, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, complex data replication, and virtualization and is the co-author of nine books on Oracle Database. Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 26 years of Oracle experience on mission- and business- critical databases. Charles presents regularly at local, regional, national, and international Oracle conferences, including COLLABORATE, VMware World, and Oracle OpenWorld, on topics of RAC, ASM, Cloud, Linux best practices, Data Guard best practices, VMware best practices, Oracle on VMware virtualization, and 7×24 high-availability considerations. Charles is the founder and president of Viscosity North America, a niche Oracle consulting company specializing in Exadata, RAC, virtualization, and Oracle Cloud. Charles is also the president of the Cloud SIG for the Independent Oracle User Group.