aioug – grepOra

Oracle Performance Tuning Internals – AIOUG NI Reunion Day

Oracle Performance Tuning Internals - AIOUG NI Reunion Day

Agenda:

09:30 – 10:00 Registrations
10:00 – 12:00 The Art of Interpreting AWR Report – Arpit, Karan
12:00 – 13:00 Exadata Performance Management and Tuning Karan, Arpit
13:00 – 13:30 Expert Panel / Q&A / Networking Arpit, Karan

Sessions Details:

The Art of Interpreting AWR Report

The AWR Report is almost the first thing which comes to the mind of any performance-tuning Oracle professional when diagnosing Oracle database performance issues. This session deeply dives into how to interpret an AWR Report correctly and its details, sections explanations to help Oracle Professionals diagnose and solve performance tuning issues. The session can be attended by DBAs, Developers, System Analysts, and System Administrators.

Exadata Performance Management and Tuning

Managing the performance in Oracle Exadata is an important task for any DBA/DMA, especially when plenty of new performance features are offered in Exadata only. Learn the performance tips, tricks, and best practices to leverage the performance in the Exadata Engineered Systems. Persistent memory and RoCE networking are offered in X8M, X9M, where the DMA must know how to configure them to achieve the best performance. Key capabilities of storage, networking and the database kernel will also be covered in the session.

For Free! Rarely used Performance Features – Part 3

For Free! Rarely used Performance Features - Part 3

There are some lesser-known performance features of the Oracle database – some of them added in recent versions – which could improve application performance significantly. Most of them are already part of the Enterprise Edition license without any additional license packs. Some of them are even available in Standard Edition. We’ll have a look at features like Index Compression, alternative storage options like Index Organized Tables and Clusters, as well as Attribute Clustering. We’ll also look at many smaller features that have been added recently, like Real-Time Materialized Views, Memoptimized Read/Write store, Parallel Execution enhancements and many more.

Randolf has been working with Oracle software for more than 25 years now, since 2000 as a freelance database consultant, focusing primarily on performance-related issues, in particular helping people to understand and unleash the power of the Oracle cost-based optimizer (CBO). A lot of related information is available on his blog and Youtube channel. Randolf is a regular speaker at some of the major Oracle user conferences and shares his knowledge as DOAG (German Oracle User Group) expert seminar instructor. Randolf is a proud member of the Oak Table Network and was part of the Oracle ACE Director program from 2011 to 2016 – current status is “Oracle ACE Director Alumni”.

Oracle Analytics Cloud and the No Code Predictive Analytics

Are you naive when it comes to making predictions using Machine learning models? Well, Oracle Analytics, with its robust Machine Learning capabilities, is here to your rescue. Without a single line of code written, here is your chance to experience OAC’s power to predict valuable results to derive meaningful insights that are critical to business.

Speaker Bio: Ambili is an Oracle Ace and Technology Architect with around 16 years of industry experience. An ardent data analytics enthusiast with a special focus on Oracle Database, Data Analytics, Big Data, and Graph DB primarily. Ambili is a frequent speaker at various OAUG, UKOUG and Oracle events. She is an Oracle Certified Professional in Oracle Database technologies and Oracle Cloud Platform Enterprise Analytics. In her own words, she is an IT professional by profession, Speaker by passion and an Artist by Soul!

Migrate Oracle Databases to on-premises and cloud with a Safety Net using Migration Workbench

Join this live demo session and Learn how to migrate databases to Exadata on-premises, to Exadata Database Service (Shared, Dedicated, or Cloud@Customer), to Autonomous, and to Base Database Service (SI, RAC, BM, or VM).
Securely migrate databases with agility while reducing the risks of human error.
Find out how SQL queries of migrated databases are automatically validated for high performance along with recommendations leveraging integrated SQL Performance Analyzer (SPA), thus ensuring your business applications continue to perform as per your requirements.

Rajendra Patil is a Principal Product Manager at Oracle. He is part of the Enterprise Manager Product management team helping customers in doing database migration using the Enterprise Manager Migration Workbench tool. Rajendra is a passionate DBA & Architect with 20+ years of experience in DBA & architecting cloud, upgrade, migrate & implementation solutions for Oracle Database, EBS, Peoplesoft, and custom applications.

Ask Me Anything (AMA) session with Mike Dietrich

Session Abstract: Have you got questions about Oracle Database Migrations and Upgrades? Come along to this session. Ask Me Anything with your question. It is an open format with no presentation. You can submit your questions in the zoom Q&A, and Mike will answer as many as possible.

Speaker Bio: Mike Dietrich is based in Bavaria, Germany and has almost thirty years of experience in the information technology industry. He has spent 24 years at Oracle Corporation where he held senior and management roles in both sales and support before joining Oracle’s Database Development organization. For over a decade he is the Distinguished Product Manager for Database Upgrade and Migrations.
In his role, Mike is responsible for evangelizing, influencing and demonstrating Oracle technology solutions related to database upgrades, migrations and consolidation to Oracle customers and partners worldwide. Besides that, he works consistently with customers in key reference projects, both onsite and remotely. He has become a patching specialist, troubleshoots upgrade and migration issues. and delivers technical workshops between the Arctic and Antarctic. Furthermore, he’s an experienced conference speaker. Mike holds a graduate engineer degree from Georg-Simon-Ohm University of Applied Sciences in Telecommunication Technologies and Computer Science. You’ll find more information on Mike’s blog: Mike is eager to learn something new every day. You can find out more about Mike on the Upgrade blog: https://MikeDietrichDE.com

Oracle Database 19c (Your next ORACLE_HOME)

Session Abstract:
This session deals with the following topics with best practices, tips, and tricks for Oracle 19c Database.

1. Oracle Database Release and Support Timelines
2. Direct Upgrade to Oracle Database 19c
3. Oracle Database Offerings / Features App
4. Zero-Downtime Oracle Grid Infrastructure Patching
5. Oracle 19c – Dynamic Services Fallback
6. Oracle 19c – Active Data Guard – DML Redirection
7. Oracle 19c – Data Guard Broker Features
8. Oracle 19c – Multi-Instance Redo Apply
9. Oracle Database 19c Important Recommended One-off Patches
10. Replicating Restore Points from Primary to Physical Standby

Speakers: Y V Ravi Kumar
Managing Director – Cloud CoE, Infolob Solutions Inc

Speaker Bio: Venkata Ravi Kumar, Yenugula is an Oracle Certified Master/ Oracle ACE Director/ Co-Author of (3) Books/ TOGAF Certified/ Maximum Availability Certified Architect/ Security Architect/ with 24 years of Multinational Leadership experience in the United States of America (USA), Seychelles and India in Banking, Financial Services & Insurance (BFSI) verticals and played various roles like Vice President (IT), Engineered Systems Architect and Enterprise Architect.

Start your cloud journey with MySQL cloud

Session Abstract:
Introduction to MDS & Heatwave
Features & Functionality
MDS with HA
Heatwave ML & Autopilot
Heatwave lake house
Competitive intelligence
Multi-cloud
Demonstration
Q & A

Speakers:Chandan Kumar
Senior Solution Architect, Oracle

Chandan Kumar has been part of the MySQL Solution Engineering team and working as a Senior Solution Architect with over a decade of rich experience in development, architecture design, administrator, support, migration on multiple databases

Rarely used Performance Features – Part 2

For Free! Rarely used Performance Features - Part 2

Session Abstract: There are some lesser-known performance features of the Oracle database – some of them added in recent versions – which could improve application performance significantly. Most of them are already part of the Enterprise Edition license without any additional license packs. Some of them are even available in Standard Edition. We’ll have a look at features like Index Compression, alternative storage options like Index Organized Tables and Clusters, as well as Attribute Clustering. We’ll also look at many smaller features that have been added recently, like Real-Time Materialized Views, Memoptimized Read/Write store, Parallel Execution enhancements, and many more.

Speakers: Randolf Eberle-Geist
Principal Consultant, oracle-performance.de

Randolf has been working with Oracle software for more than 25 years now, since 2000 as a freelance database consultant, focusing primarily on performance-related issues, in particular helping people to understand and unleash the power of the Oracle cost-based optimizer (CBO). A lot of related information is available on his blog and Youtube channel. Randolf is a regular speaker at some of the major Oracle user conferences and shares his knowledge as DOAG (German Oracle User Group) expert seminar instructor. Randolf is a proud member of the Oak Table Network and was part of the Oracle ACE Director program from 2011 to 2016 – his current status is “Oracle ACE Director Alumni”.

Ask Me Anything session with Jonathan Lewis – Theme “Indexing.”

Ask Me Anything session with Jonathan Lewis - Theme "Indexing."

Session Abstract: Have you got questions about Oracle Database Indexing? Come along to this session. Ask Me Anything with your question. It is an open format with no presentation. You can submit your questions in the zoom Q&A, and the speaker will answer as many as possible.

Speakers: Jonathan Lewis
Independent Oracle Specialist, JL Computer Consultancy

Jonathan Lewis is a well-known figure in the Oracle world with more than 30 years of experience using the software. He has published three books about Oracle – the most recent being “Oracle Core”, published by Apress Nov 2011 – and contributed to three others. He has posted more than 1,400 articles to his blog and has spent a lot of his time contributing to newsgroups, forums, and User Group magazines and events worldwide.
Jonathan has been self-employed for most of his time in the IT industry. For the last 25 years, he has specialized in short-term assignments – typically of a design, review, or trouble-shooting nature – often spending no more than two or three days on a client site to address problems. After visiting more than 50 countries (and more than a dozen US states) to talk about or troubleshoot Oracle systems, he has finally gone into near-retirement, though he still writes articles and does a little consulting over the internet.

Next Generation Database Management for DevOps and DBAs

Gain instant access to monitor and administer your entire fleet of databases, whether one or many located either on-premise or in the cloud, using Oracle Cloud Infrastructure Database Management and Operations Insights cloud services. You will see in-depth capabilities for monitoring, troubleshooting, and managing groups of databases as a single unit whether they are unrelated databases, development or test databases, or databases belonging to an application group. You will see demonstrations of typical database management workflows.