aioug

Have you been unable to answer a SQL interview question? Or unsure how to turn business requirements – e.g. “Find the two highest-paid employees in each department” – into SQL queries? This session will show you how to turn these questions into SQL. Chris will take your “business requirements” based on the sample HR schema in this live, interactive SQL coding challenge. He’ll then write SQL to answer them in real-time. Join the fun and learn the process of writing SQL.

Functions in SQL are a useful and popular feature that is often used. However, little attention is often paid to performance aspects. A function call or an expression in a WHERE condition is a challenge for the query optimizer that often leads to unsuitable execution plans and bad response times. For PL/SQL functions called from SQL, the situation is even more complex. If used incorrectly, they can lead to massive performance degradation. In this presentation, I will show different possibilities to support the optimizer in function calls to generate better execution plans. Furthermore, I will explain how PL/SQL functions can

Trust-but-verify is a key security control for many compliance regulations. In this session, you will learn how you can use Unified Auditing in Oracle Database to implement this approach in a smart and practical way while minimizing performance and storage impact on the database. Try hands-on configuring simple unified audit policies with LiveLabs workshop practice in this session. Join this session and become subject matter experts for implementing this key security control in your organizations.

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.

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

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.

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

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