Introducing Oracle Zero Downtime Migration (ZDM) 21c, the fully automated tool that leverages the best of Oracle’s high availability and scalability solutions to move your on-premises Oracle Databases to Oracle Cloud with no database downtime.
This session will cover the full range of features and functionality of Oracle ZDM in-depth, including a demo and background on how it was designed and built to meet all your migration needs.
Session Abstract: Join this session to explore how Data Guard and Active Data Guard 21c have evolved over the past five years to understand better what features and best practices can be utilized with each version. The session will cover a technical deep dive of each of the new features, including the long-awaited Multitenant Data Guard feature that allows for the choice of PDB or CDB level failover.
– Learn some simple techniques to optimize the performance of your Oracle, RAC, and Exadata databases.
– Learn how you can lower latency and reduce your DB IO.
– Learn how these techniques can work on bare metal, VMs, and Kubernetes.
– Warning, SQL explain plans and indexes may be involved.
Speaker BIO: Douglas Hood
Consulting Member of Technical Staff, Oracle
Doug is a Consulting Member of Technical Staff at Oracle.
Doug is an evangelist for Oracle TimesTen, Oracle NoSQL, and Oracle In-Memory.
Doug is passionate about performance, high availability, and simplicity.
Oracle Database provides the industry’s most comprehensive and flexible auditing capability. Effective audit policies let you monitor database activity with a negligible performance impact. In this session, you’ll learn how to create audit policies that are selective and targeted to your needs, avoiding the common pitfall of collecting unnecessary audit information that, in turn, impacts database performance, increases storage costs, and may make it more difficult to spot malicious activity. Angeline Dhanarani, Principal Product Manager for Database Auditing, will share key tips to capture relevant audit events, reduce false positives, and support quick and reliable threat detection – all without compromising database performance!
Speaker BIO: Angeline Janet Dhanarani
Principal Product Manager – Core Database Auditing, Oracle Audit Vault and Database Firewall (AVDF), Oracle
Angeline Janet Dhanarani is the Principal Product Manager for Oracle Database Security, focusing on core Oracle Database Auditing and database activity monitoring (DAM) solutions with Audit Vault and Database Firewall (AVDF). With 17+ years of experience, Angeline is involved in many customer engagement activities for over a decade at Oracle. Angeline is engaged in inbound and outbound product management activities and is responsible for ensuring the successful adoption of DAM solutions in many large financial establishments. Angeline closely works with the engineering team to define the product roadmap.
In this session, learn about the new capabilities in the just-released Oracle Enterprise Manager 13c Release 5 that allows Oracle Databases to be deployed in the cloud or on-premises and stop worrying about the operational risks and management of these databases.
This session covers the exciting features of Oracle Enterprise Manager 13c Release 5 in the following key areas:
– Hybrid Cloud Management: Fleet monitoring, management and data movement across the entire IT estate – on-premises and in the cloud including Exadata Cloud@Customer, Exadata Cloud Service, Oracle Dedicated Region Cloud@Customer, Autonomous Database, and Oracle Databases deployed elsewhere
– Ops Automation: Enhanced automation and modernization with smart performance analytics, dynamic run books, database provisioning, patching, security, and compliance
– Extensibility: Open standards-based extensions for interoperability with 3rd party ecosystems with REST APIs, custom dashboards, and mobile app
Speaker BIO: Prabhaker Gongloor
Senior Director of Product Management, Oracle
Prabhaker Gongloor (GP) works as Senior Director of Product Management at Oracle Corporation in the Cloud and Systems Manageability group covering numerous products – Oracle Enterprise Manager, Oracle Management Cloud, and OCI native services. His primary focus areas are Performance Diagnostics, SQL Tuning, DB and Engineered Systems Manageability, and Real Application Testing. GP has over 28 years of industry experience spanning many roles – Developer, Consulting Technical Advisor (Centers of Expertise), and Consulting Product Manager. He holds Bachelor’s and Master’s degrees in Computer Science and Engineering. GP has contributed significantly towards building Oracle’s Database Manageability solutions and has multiple patents to his credit. He has presented numerous sessions at OOW and user conferences and some of his sessions have been rated the best in their category.
This session will focus on using AWR reports to tune OLTP and DSS workloads running on Oracle Real Application Clusters (RAC) both on generic systems and Exadata. This includes hints and tips to focus on relevant sections of the AWR report to quickly understand the root cause of the problem. Further, we will review AWR reports of some interesting real-world performance issues reported by customers and the diagnostics involved in resolving them
Speaker BIO: 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 its inception. He has helped various customers with Oracle solutions specifically around Performance, availability, Scalability aspects for about 20 years
Materialized Views are very useful to increase the performance of frequently executed queries. In many database applications, Materialized Views are accessed directly using SQL. However, the use of Query Rewrite is much more elegant and flexible: The optimizer decides independently whether a suitable Materialized View can be used to accelerate the query. The goal is to be able to improve the performance of different queries with the smallest possible number of Materialized Views. Query Rewrite offers excellent possibilities for this.
Although Query Rewrite is available in Oracle databases for a long time, the feature is still unknown to many Oracle developers and database administrators, or it is not used due to its complexity. This presentation shows the power of Query Rewrite, how it is configured correctly, what has to be considered when creating Materialized Views and which new features have been introduced in versions 12.2, 18c, and 19c.
Speaker BIO: Dani Schnider
Senior Principal Consultant, Trivadis AG
Dani Schnider works as Senior Principal Consultant for Trivadis, a Swiss IT consulting company. He finished his studies in computer science at ETH Zurich in 1990. Since 1994, he is developing data models and applications with Oracle databases, 1997 mainly in data warehousing projects.
Most of his time he is doing jobs for customers in the design, data modeling, ETL development, architecture reviews, and performance optimization of Oracle data warehouses. He is a teacher for several Oracle training at Trivadis and co-author of the (German) books «Data Warehousing MIT Oracle – Business Intelligence in der Praxis» and «Data Warehouse Blueprints.
SQL monitor reports have been around for a long time. They are extremely useful in diagnosing the performance of a single execution of a SQL statement. Next to AWR, ASH, and SQL-trace, they are a tool every performance engineer should be comfortable with. In this session, we will introduce you to active SQL monitor reports. We’ll first explain when SQL monitor is available, how to generate them, and discuss the anatomy of a SQL monitor report. In the 2nd part of this session, we’ll go through a few example SQL monitor reports, and show how to use them to find the root cause of a poorly performing SQL statement.
Speaker BIO: Toon Koppelaars
Real-World Performance, Oracle
Toon has been part of the Oracle ecosystem since 1987. He is currently a member of Oracle’s Real-World Performance team. The RWP team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development.
Session Title: Fireside Chat with Security Gurus
Session Abstract: Join our interactive session where Manish, Angeline, Russ Lowenthal will answer your questions live. In this session, get the unique opportunity to engage with your peers on relevant issues on Oracle Security. You can pre-submit these questions by tweeting @AIOUG #aiougFC or ask live in the chat.
Speaker Bio: Manish Choudhary
Product Manager – Oracle Data Safe, Sensitive Data Discovery, Data Masking, and Subsetting, Oracle
Manish Choudhary is a product manager for Oracle Database Security, focusing on sensitive data discovery and masking technologies. He has experience in database firewall, activity monitoring, and security analytics areas also. Manish has nine years of experience in the security domain. Prior to joining the Oracle Database Security team, he worked with the Oracle Solaris group as the security and compliance product manager. During his time at McAfee Labs, he worked on Host Intrusion Prevention System and Database Activity Monitoring.
Manish has an MS in Security from Georgia Institute of Technology, Atlanta. His interest areas are data security and privacy, cryptography, cloud security, cyber-physical systems (IoT), and machine learning in security.
Speaker Bio: Angeline Janet Dhanarani
Principal Product Manager – Core Database Auditing, Oracle Audit Vault and Database Firewall (AVDF), Oracle
Angeline Janet Dhanarani is the Principal Product Manager for Oracle Database Security, focusing on core Oracle Database Auditing and database activity monitoring (DAM) solution with Audit Vault and Database Firewall (AVDF). With 17+ years of experience, Angeline is involved in many customer engagement activities for over a decade at Oracle. Angeline is engaged in inbound and outbound product management activities and is responsible for ensuring the successful adoption of DAM solutions in many large financial establishments. Angeline closely works with the engineering team to define the product roadmap.
Speaker Bio: Russ Lowenthal
Senior Director of Product Management for Database Security, Oracle
Russ Lowenthal is the Senior Director of Product Management for Database Security, focused on database encryption, access control, audit, and monitoring. Russ is based in Orlando, Florida, USA, and has been with Oracle for over twenty years. Leveraging more than thirty years of experience in IT including database, UNIX systems, and network administration, he now advises Oracle’s customers on secure implementations of information systems technology. Russ’ certifications include Certified Information System Security Professional (CISSP), Certified Information Systems Auditor (CISA), Certified Information Systems Manager (CISM), Oracle Certified Master (OCM), Microsoft Certified Systems Engineer (MCSE), and Certified Technical Trainer (CTT).
Oracle Cloud-Native Journey Session 6: Digital Assistants and Chatbots
Session Abstract: In this session, you will learn.
– Basics of Oracle Digital Assistant
– How to create a small conversational bot
– Basics of a chatbot: intents, entities, utterances
– Testing your own bot
Speaker BIO : ROLANDO CARRASCO
CTO, Services and Processes Solutions S.A de C.V
Rolando Carrasco is both an Oracle ACE Director and Oracle Groundbreaker Ambassador focused on modern technologies and architectures. Rolando has been in the IT industry for more than 20 years, always involved in the integration space and areas that derive from it, such as Services Orientation, Event-Driven Architectures, Cloud Native, Microservices, API Management. Rolando has been the author of technology books as well as a technical reviewer, the last book where he was involved as a technical reviewer is: Enterprise API Management (https://www.amazon.com/-/es/Luis-Weir/dp/1787284433). He is been focused on modern architectures and trying to move customers from their old fashion architectures to modern ones. Currently, he is involved in projects related to API Management, Cloud Native Development, Integration, CI/CD, as well as involved within his company to develop packaged solutions for their customers. Rolando started as a technical consultant in Hewlett Packard (back in the year 2000), moved to Oracle in 2002, and in 2010 he started his own consulting firm name SPS. His current interests, and where he is currently investing his time are around Kubernetes, Cloud Native Patterns, Automation, and API Management. Those are his areas of interest, and where is trying to get more experience. He is a constant speaker for local and international conferences, such as Oracle Open World, Oracle CODE ONE, etc. He is the current President of the Latin American Oracle Users Groups (LAOUC), and he is also the leader of the Mexico Oracle User Group. He is in charge of coordinating the Oracle Groundbreakers Tour in Latin America, among other several activities related to the user’s groups.
Speaker BIO: SURESH GANDHI
Senior Manager, Qualcomm India Pvt Limited
Suresh Gandhi is Senior Manager in Qualcomm India Pvt Limited leading database teams. He has 20 years of experience in Databases, Middleware & Management. He is volunteering as Independent Director for the Independent Australia Oracle User Group (AUSOUG). For more than 7 years, he shares his learnings & knowledge in his blog (http://db.geeksinsight.com) and presented various topics in AIOUG, IAOUG, AUSOUG, APACOUC, and Oracle Code One events in APAC regions. Alongside Oracle knowledge, he added proficiency in Big Data and NoSQL Databases. Suresh also experienced in designing new generation data lakes for Enterprise Datawarehouse using Cloud platforms like AWS & Oracle Cloud. He has adept knowledge in DevOps & Automations. He is certified in Oracle, AWS & ITIL Certified and holds a bachelor’s degree. He is also a trainer and delivered many sessions & Webinars in Performance Troubleshooting, Building Data lakes, NoSQL Technologies. He strives to adapt to the latest trends in database technology in his work and shares his experiences with the community. He is reachable at [masked] or @geeksinsights on Twitter or leaves a comment on his blog.
