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 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: When 7-bit ASCII ain’t enough – about NLS, Collation, Charsets, Unicode and such with Kim Berg Hansen

Greetings from All India Oracle Users Group (AIOUG)! We hope everyone at your end including you are safe!

The Covid-19 makes the user group events that are physical gatherings impossible. Over the past weeks, we have been looking at our calendar of events and re-imagining them as virtual web-based events. We have decided to host virtual based sessions every Wednesday. Please mark your calendars and find more details about this week’s webinar.

Session Title: When 7-bit ASCII ain’t enough – about NLS, Collation, Charsets, Unicode and such

Session Abstract:  A-Z in upper and lower case isn’t enough in a global world, you need to support all sorts of textual data. Oracle database can handle most of it, but there are pitfalls to be aware of – even using Unicode that should handle everything. Learn about NLS and collation and converting charactersets.

Session Description: How life as a DB developer would be much easier if the entire world was happy with just A-Z in upper and lower case. But the globalized world is a very diverse place with myriads of special characters and modifiers, different alphabets, writing directions, sorting and comparison rules, and many ways to encode these characters. So, your database and application absolutely need to know about these things and handle them correctly, or you’ll find your app displaying garbage or worse, storing garbage.

Oracle database offers many NLS (National Language Support) settings to handle such globalization on database, instance and session/client level. NLS functions are available in the SQL language to handle specific cases with code when the session settings aren’t granular enough. In Oracle 12.2 was added Collation support, where you specify right down on column level how this column should sort and compare values. You have choices whether to store everything with database characterset UTF8 or stick to a single-byte characterset – in both cases be aware of how conversion takes place if the client is not using the database characterset.

This presentation discusses many of the issues involved and ways to use NLS and Collation to avoid them. Pitfalls will be shown, where you can get mangled (or even invalid) data stored if you are not careful.

Speaker Bio:

Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay, as the programs he did worked well be unlike the electronics projects he soldered that often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which last two languages he now has worked with extensively since the year 2000. His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for the users.

Kim shares his experience and knowledge by writing the “Practical Oracle SQL” book, blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is certified Oracle OCE in SQL as well as awarded Oracle ACE Director. Outside the coding world, Kim is married, loves to cook, and is a card-carrying member of the Danish Beer Enthusiasts association.

Date: 29th July 2020
Time: 2:00 – 3:30 pm IST

Registration Link:

If you are AIOUG Member – Click Register Button

If you are Non AIOUG Member – Please sign up for “Starter (FREE) Membership” from https://www.aioug.org/join and Register

Upcoming Webinars: Please check the following page for our upcoming webinars and register to secure your seat.


We are looking at how we can deliver quality content and benefit to our members. We have some ideas including webinars of course but do you have any ideas of what you would like to see the AIOUG doing for you? If so, please get in touch – webinar@aioug.org


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