Viscosity Upcoming Events

View Past Events

August 23-27, 2021 – Virtual Conference

 

Quest community database & technology week

Registration opens july 26, 2021

Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Oracle ACE Associate

Viscosity North America

 

Deep dive into SQL Tuning

Mon aug 23, 2021, 2:00 PM – 3:00 PM ET

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

1. What tools are available for deep diving into a SQL statement?
2. When would you use each of these tools, and how do you understand the output?
3. What are some of the ways to force the optimizer to behave the way I want it to?

Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Oracle ACE Director

Viscosity North America

 

Machine Learning for Business Leadership

Tue aug 24, 2021, 11:00 AM – 12:00 PM ET

This presentation will focus on what specific algorithms inside Oracle can be applied to business problems. Robots may be the first to truly learn machine learning (ML) and expand into artificial intelligence (AI). Python is one of the keys to machine learning as we program the invention of the mind to further replace humans’ most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, and some relate to customers we don’t know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.

 

September 14, 2021 – Webinar


“Tune that SQL” now what do I do?

11:00 AM – 12:00 PM Central

Gary Gordhamer

Gary Gordhamer

Managing Consultant, Viscosity North America

Oracle ACE Associate

 

Tuning SQL statements in Oracle is more of an art than a science. In this session we will cover the basic tools and steps to tuning a SQL statement. Starting with finding the SQL statement and collecting the right information. How does the Optimizer work to transform SQL into an execution plan? What information is an execution plan is trying to show? Finally, what are some of the things that can be tuned as well as tools Oracle has provided to make things easier. If you are new to tuning SQL in Oracle or trying to freshen up your skills, this session should have enough information for everyone.

Finding SQL statement
– Top SQL by?
– what information about a SQL to collect

The Oracle Optimizer
– steps
– explain plan – execution plan
– bind peaking
– soft parse vs hard parse

Details in explain plan
– basic plan
– collected statistics
– estimate vs actual

What to tune?
– change the code
– change the statistics
– change the way Oracle works

Tools to help
– SPM
– Profiles
– Patches
– SQL Tuning Advisor

Q&A

Presented by Gary Gordhamer, Managing Principal Consultant, Viscosity North America

Co-Hosted by the New York Oracle Users group (http://nyoug.org/) and Viscosity North America.

 September 23, 2021

 

Educational Workshop by Viscosity consultant, Sean Scott

1:00 PM – 2:30 PM CT

RMOUG is hosting Viscosity consultant and Oracle ACE, Sean Scott, to present a 90 minute workshop on running Oracle Databases in Docker containers.   Register now!

October 5, 2021 – Webinar


Oracle SQL Developer Tips & Tricks – Desktop, command-line, or Web!

11:00 AM – 12:00 PM Central

Jeff Smith

Jeff Smith

Distinguished Product Manager, Oracle Corporation

Join us for an hour as the product manager takes you on a tour of all the productivity features across all of our development and management interfaces for the Oracle Database.

This session is meant to be interactive and fun! These are the tips that will save you time on every mouse-click or keystroke.


Presented by Jeff Smith, Distinguished Product Manager, Oracle Corporation

It’s Jeff’s mission to help you be successful with Oracle Database using Oracle database tools. Jeff empowers users across the globe with Oracle SQL Developer, Oracle SQLcl, Oracle SQL Developer Data Modeler, and Oracle REST Data Services.

Nearly two decades experience in the commercial software industry with a customer-driven focus. Support, testing, documentation, product management and marketing, pre and post sales support – helping customers succeed and and making the most of their technology investments.

Specialties: Oracle Database, technical writing, software product demonstrations, online community development, 1st & 2nd level software support, public speaking, Social Media advocate, product marketing and evangelizing, product and technology course design and training delivery, software asset discovery and management

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)

October 19, 2021 – Webinar


What’s New from Oracle Database Development

11:00 AM – 12:00 PM Central

Willie Hardie

Willie Hardie

VP, Database Product Management, Oracle Corporation

Learn the latest news and updates directly from the Oracle Database Development Team. In addition to discussing some of the latest features and enhancements, this session will also cover Oracle Database strategy with regard to on-premises, in-cloud and hybrid cloud deployments.

Presented by Willie Hardie, VP, Database Product Management, Oracle Corporation

William Hardie is responsible for Oracle Database product management, focusing on growing Oracle’s business in the global database, data warehousing, and embedded database markets.

His area of expertise includes Oracle Database, Oracle Exadata, Oracle Real Application Clusters, Oracle In-Memory Database Cache, Oracle Advanced Compression, and other key Oracle Database options.

Hardie has been in IT for more than 25 years and has specialized in relational database technologies for more than 20 years. Originally from Edinburgh, Scotland, he has worked with Oracle Database since Release 5.

Co-Hosted by the New York Oracle Users group (http://nyoug.org/) and Viscosity North America.

Don't see your city?

Let us know if you want to see events like this in your city!  Email us your name, location, organization or interests, and what type of event you’d like to see.

We’ll track what cities have the most demand and do what we can to make it out towards you!  Till then, keep checking back for online events!