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
APACOUC (APAC Oracle Users Groups Community) was formed to unify all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and to help the grow of all the communities within Asia Pacific. Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 9 years, APACOUC have organized the APAC Groundbreakers tour that brought Oracle Celebrities to many countries, such as per example:
APACOUC (APAC Oracle Users Groups Community) was formed to unify all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and to help the grow of all the communities within Asia Pacific. Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 9 years, APACOUC have organised the APAC Groundbreakers tour that brought Oracle Celebrities to many countries, such as per example:
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
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!
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
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
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.
Session Abstract: Storage is one of the most critical tiers in any database technology, The Exadata Storage Server runs the Exadata Storage Server Software and it provides several features like Smart Scan, Smart Flash Cache, Smart Flash Logging, IO Resource Manager, Storage Indexes and Hybrid Columnar Compression. Managing them becomes very important, take a deep dive into Exadata Storage Server Internals to know more on it. Speakers Karan Dodwal Oracle Exadata Consultant, Fidelity International Karan Dodwal is an Oracle ACE and Oracle Certified Master (OCM) with specialization in Oracle Cloud, Oracle Exadata and Performance Tuning, he works with Fidelity
Session Title : 3-in-1: New Features for DBA's in Oracle 18c/19c/21c(20c) - Part 2 Session Abstract: This session covers the most important and relevant 100 new features in the Oracle 18c, 19c & 21c (21c) database. Oracle DBA/Develops can take advantage of those new features. The list includes a wide variety of generic features, performance tuning related enhancements, touching multi-tenant improvements, some overhauled features, and as well as security posture features. Join this session and surely you will take away a lot and loads of new features in the latest release of the Oracle database Speaker BIO: Suresh Gandhi Senior
Session Title: Oracle 21C: Data Guard Broker New Features Session Abstract: Oracle 21c is released with some new features. In this session, we will talk about the new features for the Data Guard Broker. We will see how to : -) Prepare our database for a Data Guard environment -) Validate our Fast Start Failover configuration -) Configure Failover Callout Configuration Scripts -) See changes about the observer -) Easily create Far_Sync -) The default location for Client-side Broker Files -) See the de-supported features -) And many other things -) We will analyze and give feedback about these new
Migrate to Oracle Cloud Infrastructure with Ease: Use Enterprise Manager Migration Workbench to Consolidate, Migrate, and Analyze Databases to OCI, Exadata Cloud or On-premise Data Centre Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of the industry-leading database, Oracle Autonomous Database, eliminating human labour and error. For Database Cloud Services running on Oracle Cloud Infrastructure or Exadata Cloud at Customer, Enterprise Manager helps DBA’s, consolidate databases and assess