aioug – Page 5

What the Heck is the Oracle Optimizer Doing? Part 2 – Plan Costing

O que diabos o Oracle Optimizer está fazendo? Parte 2 - Plano de custos

Session Abstract:

When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage.

This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.

Note: This webinar session not planned for recording, please attend the live session only.

Speakers

Neil Chandler

Database Guy, Chandler Systems

Neil has been working in IT since 1988, and with Oracle software since 1991.

He is an independent consultant who specialises in Performance Tuning, RAC, DataGuard, Goldengate, Upgrades, Data Migration, with some PL/SQL and Apex Development for good measure.

He likes to drink strong smooth Italian coffee, good beer and better whisky, depending upon the time of day.

Neil is an Oracle ACE Director, and a board member of the UKOUG

Migrating MySQL from AWS to OCI

From: https://www.aioug.org/events/migrating-mysql-from-aws-to-oci

MySQL engineering team supported MySQL Database Service (MDS) is now available on the Gen 2 Oracle Cloud Infrastructure (OCI). There is huge interest in moving MySQL workloads to the Oracle cloud because of its cost-effectiveness. Customers also want the best possible support available to them from the MySQL engineering team. This talk will give you insights to help move your MySQL workloads to OCI. We will share best practices, tips and tools to ensure that you are able to make this move effectively and fast.

Agile and DevOps for the Oracle Cloud

From: https://www.aioug.org/events/agile-and-devops-for-the-oracle-cloud

Get to know Oracle’s solution for managing the lifecycle of your code and the development process for your team. In this session we’ll demonstrate Oracle’s offering for code version management continuous integration and delivery (CI/CD) and agile team collaboration – all integrated in one tool available as part of your Oracle cloud account. Get to know Oracle Visual Builder Studio and how it can improve your team development across infrastructure, database, and applications c

Growing Momentum Around Oracle Blockchain Technology

From: https://www.aioug.org/events/growing-momentum-around-oracle-blockchain-technology

Oracle has released a new Blockchain Tables capability in Oracle Database and a significant update to the Oracle Blockchain Platform Cloud Service, leveraging the advantages of Oracle Cloud Infrastructure (OCI) Gen2 and new advancements by the Linux Foundation open source community in Hyperledger Fabric. As our blockchain customers are increasingly moving their applications into production and existing production customers are scaling up their deployments and ramping up their transaction volumes, this new release responds to their needs. Learn about the increased resilience and even higher availability, dynamic scale-up and scale-out to handle ever-growing workloads, stronger access controls for sharing confidential information, superior price/performance, greater decentralization capabilities for blockchain consortiums, and stronger audibility when using rich history database feature together with Oracle Database Blockchain Tables. We’ll also discuss the latest solutions and customer use cases leveraging blockchain platform and blockchain tables.

Assessing your database security – Top 10 findings

From: https://www.aioug.org/events/assessing-your-database-security-top-10-findings

Attend this session to learn the top 10 common findings from customer assessments and how to assess your Oracle Database security. Getting to a hardened Oracle Database configuration is easier than it seems. Know your current security state by executing a couple of commands and start including STIG, CIS, GDPR, and Oracle best practices into your security assessment methodology today!

Augmented Analytics with OAC

From: https://www.aioug.org/events/augmented-analytics-with-oac

This session will introduce Oracle Analytics Portfolio to the audience. The focus will be to understand the Augmented Analytics features and how they help business users to go about their data discovery and exploration process. You will see how to get started with any “data-set” that you need to analyze. Oracle Analytics gives you intelligent insights to any data that you bring in. It helps you create visuals with Natural Language Query, no need to learn any query language. See how the entire process of curating data is made easy for business users, helping them make the data set relevant before they start their data visualization journey. Connect to any data anywhere. This session will prepare you to get started with ML features embedded in Oracle Analytics Cloud, which will be covered in later sessions. You have labs to take away, get hands-on experience.

Introduction to Oracle Analytics Cloud (OAC) – 15 minutes
- Introduction to Analytics solution family (OAC/OAS/FAW)
- OAC editions
- OAC self-service
- OAC enterprise analytics (semantic model)
Augmented Analytics with OAC – (50 minutes)
- Intelligent insights – Data Discovery
- NLQ based visuals
- Automated Data preparation
- Mobile Analytics (Day by Day)
Access and Prepare “Any Data” for Analytics– (15 minutes)
- Data connectors
- Data Flow
Takeaway Hands-On-Labs (10 minutes)
Q&A

AIOUG Webinar: Shareable Cursors with Christian Antognini

Session Title:
Shareable Cursors

Session Abstract:
The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused? The aim of this presentation is not only to discuss what parent and child cursors are but also, and foremost, to examine in what situations it is possible to reuse them. In doing so, topics such as bind variable peeking, bind variable graduation, adaptive cursor sharing and statistics feedback will be covered as well.

Christian Antognini

Senior Principal Consultant, Trivadis

Christian Antognini is a strong believer that at the core it is all about the data, and on how effectively companies process and take advantage of it. For that reason, since 1995 he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and basically everything else related to data processing and application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.

If Christian is not helping one of his customers get the most out of databases, he is somewhere lecturing on application performance management or database performance features. In addition to classes and seminars organized by Trivadis, since 2001 he has presented at 100+ conferences and user-group meetings in two dozen countries. He is a proud member of the OakTable Network and is an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011/2016).

AIOUG Webinar: 5 minutes to upgrade all your databases with AutoUpgrade

Whether you have 3 or 3000 Oracle databases to upgrade, AutoUpgrade is your best friend. A config file is adjusted in less than 5 minutes – and then you kick off the database upgrade. Oracle Database 19c is our target – but you can use it also for upgrades to 12.2.0.1 and 18c – if you really want to do this. But there’s more, much more. You can plugin your database after upgrade into a CDB. And you can tweak and adjust many settings – if you need to. We will drill down into the settings of AutoUpgrade. Plus a demo will be included as well. At the end of this session, you’ll use the only AutoUpgrade to upgrade Oracle databases – and upgrade has never been easier before.

Mike Dietrich

Distinguished Product Manager, Oracle

Based in Bavaria, Germany. >25 years of IT experience. Holding a degree as Graduate Engineer (Dipl. Ing. NT/DT) in Data Systems and Information Technology of Georg-Simon-Ohm University of Applied Science, Nuernberg, Germany.

Distinguished Product Manager for Oracle Database Upgrade and Migrations, patching specialist, working for Oracle for far over 20 years. Interlink between customers/partners and Oracle Upgrade Development. Holding technical workshops between Arctic and Antarctica. Assisting customers in their reference projects onsite and remotely worldwide. Troubleshooting upgrade and migration issues. Eager to learn something new every day. Experienced conference speaker. Music lover. LP/vinyl enthusiast. Mountain hiker. Cyclist.

See more on Mike’s blog: https://MikeDietrichDE.com

AIOUG Webinar: Do not run-away! Oracle Performance for the Uncertain

Session Title:
Do not run-away! Oracle Performance for the Uncertain

Session Abstract:
It’s eternal. Autonomous Database yes, Self-driving maybe – at the end, one of us has to put boots on the ground if there are shortcomings in real throughput or latency. In the cloud, analysis is a bit harder, on-premises has a few features less. The Oracle RDBMS is changing, but architecture, the way how it works and its limitations are still very similar on all platforms. One dilemma will stay with us: Using precious and finite resources efficiently, while valuable time passes mercilessly.

With this background, I’d like to show you in theory and practice, how Oracle uses resources. How you can analyze with Oracle’s on-board tools what currently is going on, and how you derive from that how to proceed. There is much to influence the runtime behavior: We’ll talk about Queueing Theory, Wait Events, AWR/Statspack, ASH, Indexes, Statistics, the optimizer, software developers, users, and the janitor.

Even runaways are a topic of this entertaining session: They will bite you one day, and you have to be aware!

This talk was made for experienced Administrators and DevOperators, who want to learn more about performance analysis and its background.

Martin Klier

Managing Partner, Performing Databases GmbH

Being in IT business as a specialist for Linux, Martin Klier has been involved in the administration of Oracle Databases for about fifteen years now. The integration of large Oracle-based high-availability solutions (MAA) with RAC and Data Guard were the first challenges. In the last years, he largely moved into performance analysis and tuning of complex systems with dynamically changing load profiles.

Skeptical needs assessments, thorough architecture planning, decent system sizing, critical benchmarking and experienced load-focused system analysis are Martin’s formula to success in avoiding production downtime.

For years now, Martin can be found speaking on topics regarding “Oracle Core, Performance and High Availability” on various national and international conferences, like COLLABORATE (IOUG), Oracle Open World or DOAG Konferenz.

Martin frequently blogs about recent issues and their solutions at http://www.usn-it.de and is known on Twitter as @MartinKlierDBA.

Martin works a lot for the community, especially for the German Oracle Users Group “DOAG” and Linux User Group Mitterteich, and is an Oracle ACE Director (Database).

AIOUG Webinar: Oracle RAC performance optimizations on Exadata with Anil Nair

Session Title:
Oracle RAC performance optimizations on Exadata

Session Abstract:
This presentation focuses on Oracle RAC optimizations on Exadata. The session will cover the Cache Fusion features which adapt to available hardware for optimal performance. This will include a broad range of topics like Multi-Tenant, Clusterware, ASM and In-Memory specific optimizations in Exadata implementation. It is quite remarkable how components of Oracle RAC work differently on engineered systems. There is an incredible amount of software engineering that goes in to ensure that the system scales efficiently.

Anil Nair

Sr Principal Product Manager (RAC), Oracle USA

Anil Nair is the Product Manager for Oracle Real Application Clusters (RAC). Oracle RAC is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide highly scalable and available database solutions for all your business applications.

Anil has been involved with Oracle RAC since inception. He has helped various customers with Oracle solutions specifically around Performance, availability, Scalability aspects for about 20 years