Viscosity Day!

Thursday, August 15th 2019, 9:30-6:00

                                             August 15th, 2019
                                         Location: Firehouse Grill
                                           4785 Lake Forest Drive
                                             Blue Ash, OH 45242

 

Please come join us for a day with our meeting sponsor, Viscosity North America with a lineup of Industry Expert Speakers listed below:

BIO:

Charles Kim – CEO, Founder and Oracle ACE Director

Charles is an Oracle Certified DBA, Certified Exadata Implementation Specialist and a Certified RAC Expert. He has co-authored nine books on Oracle Database. Charles regularly presents at local, regional, national and international Oracle conferences, including COLLABORATE and Oracle Open World.

Alfredo Kreig – Oracle ACE

Alfredo is a Senior Cloud Performance Architect and Oracle ACE at Viscosity.  He specializes in Database performance tuning, Exadata, OEM and EBS. He has been using Oracle Technologies since 2004 Alfredo has presented at Oracle Open World, COLLABORATE and RMOUG.

Abstracts:

Overview of Oracle’s Engineered Systems – Oracle ACEs
Oracle Database 12c Release 2 (Oracle 12.2/18c/19c) is the fastest state-of-the-art revolutionary database in the world.  Companies can significantly see immediate ROI by upgrading to Oracle Database 12.2/18c/19c.  Oracle customers need to upgrade to Oracle Database 12.2/18c/19c and unlock the full potential of the new database features and transform their IT infrastructure.


Bulletproof your Data Guard Configuration – Charles Kim Oracle ACE Director
Learn the pitfalls to common Data Guard configuration issues. Not only will we review the common Data Guard configuration issues that most of the customers face, we will provide tips and tricks to avoid the situation. More importantly, we will share our industry expertise to show you how to  resolve the issues.  We will also demonstrate how you can proactively monitor and maintain your Data Guard configuration so avoid disasters, tune the transport layer, and minimize out-of-sync conditions.


We will disseminate Data Guard best practices and reference architectures that DBAs and architects need to know to protect their Oracle ecosystem. Pertinent Oracle Database 12.2/18c/19c new features will be shared.  The session concentrates on:

Building the physical standby
Monitoring and maintaining the physical standby
Configuring Data Guard Broker
Performing backup and recovery with RMAN
Setting archive retention
Performing switchovers and failovers
Integrating Data Guard with OEM 13c
What’s new in Oracle Data Guard 12.2/18c/19c

Oracle Enterprise Manager in Action – Alfredo Krieg Oracle ACE
Oracle Enterprise Manager 13c provides the single pane of glass that allows Architects and DBA’s monitor and manage the Oracle ecosystem.. In this session, learn how Oracle Enterprise Manager simplifies management of the databases and including the Oracle’s Engineered Systems. This presentation covers the monitoring aspects of the Oracle’s engineered systems, techniques in order to find performance problems affecting the databases, and will cover the latest new features in OEM.

Oracle Enterprise Manager, provides comprehensive and centralized monitoring capabilities for the Oracle Engineered Systems, including the Oracle Database Appliance and Exadata Database Machine.

Performance monitoring
Identify wait events
Create custom metrics to send alerts
Learn the latest features in OEM 13c

Listen to your database. How to understand an Oracle AWR report - Alfedo Krieg Oracle ACE

Is sometimes difficult to quickly identify the root cause of a performance issue in the database. Automatic workload Repository (AWR) contains most of the information needed to identify these issues, but it could be overwhelming due the amount of data and statistics. Then, there's a need of a method to quickly identify if the database system is CPU or I/O bound along with the top SQL statements in that period of time.

This session will explain how to identify the time consumed and the time waited by the database. It also drills down to particular SQL statements responsible of this time consumed.

 

Meeting Agenda

09:30a - 09:50a        Meeting Registration/Check-in
09:50a - 10:50a        Overview of Oracle’s Engineered Systems – Oracle ACEs
10:50a - 11:00a        Break
11:00a - 12:00a        Bulletproof your Data Guard Configuration – Charles Kim
12:00p - 01:00p        Break and Lunch Sponsored by Viscosity
01:00p - 02:00p        Listen to Your Database. How to Understand an Oracle AWR Report - Alfred Krieg
02:00p - 02:10p        Break
02:10p - 03:10p        Oracle Enterprise Manager in Action – Alfredo Krieg
03:10p - 04:00p        Q&A, Announcements, Gift Drawing
04:00p - 06:00p         !!! Happy Hour at the Firehouse Grill, 4785 Lake Forest Dr. Blue Ash Ohio !!!

Registration has changed. You now create an account on our website and then register for your meeting. This will help when ordering food and drinks: (http://www.gcoug.org/events.php). A sign in sheet will also be available at the meeting room but please email president@gcoug.org if your attending.

There generally is a $25 admission cost for non-members but Viscosity will waive this fee for new guests of Viscosity to attend the Technology Day.

 

DIRECTIONS TO Firehouse Grill:

From Greater Cincinnati/Northern Kentucky Airport:
  - As you are leaving the airport, follow the signs to East I-275.
  - Merge onto I-75 North via Exit 84 toward Cincinnati.
  - Stay on I-75 crossing over the Ohio River into Ohio.
  - Take I-71 North RIGHT AFTER the bridge.
  - Continue I-71 North to exit 15 (Glendale Milford Rd/Pfeiffer Rd).
  - Turn left.
  - Stay in far-right lane and go past Kenwood Rd.
  - Take next Right onto Lake Forest Drive….. You should see the restaurant.

From Dayton, OH:
  - Take I-75 South to East I-275.
  - Take the I-71 South to Cincinnati ramp.
  - Continue I-71 North to exit 15 (Glendale Milford Rd/Pfeiffer Rd).
  - Turn left.
  - Stay in far-right lane and go past Kenwood Rd.
  - Take next Right onto Lake Forest Drive….. You should see the restaurant.

From Columbus, OH:
  - Take I-71 South to Cincinnati.
  - Go under I-275 and continue I-71 South to exit 15 (Glendale Milford Rd/Pfeiffer Rd).
  - Turn Right.
  - Stay in far-right lane and go past Kenwood Rd.
  - Take next Right onto Lake Forest Drive….. You should see the restaurant.