New Mexico Oracle Users Group Tech Day

Messaging apps do more than facilitate communication—they're hubs that accelerate work along its journey from idea through completion. Slack and MS Teams plugins shift the work once performed in dedicated tools into chat's single, familiar interface. What began as simple applications that connected people and teams are now indispensable platforms that join people to processes, increase productivity, and ignite collaboration.

One of the last frontiers for integration is connecting chat to databases—an idea that might seem, at first, to offer little value. Yet just as chat plugins streamlined other workflows, enabling database-to-chat communications can revolutionize how organizations access database resources. Simple, standardized APIs let organizations quickly build custom applications on top of trusted applications and leverage the platform's existing role-based access and channels.

This session begins with an introduction to database-to-chat integrations possible through Oracle built-in packages, including the new DBMS_CLOUD_NOTIFICATION package. You'll learn how to set up and secure passive notifications from an Oracle database to clients, then discover ways to extend this relationship—deploying a fully interactive platform that allows users to issue database commands directly from a chat client. The session concludes with example applications, a discussion of best practices, and coverage of security strategies and considerations.

Production patching and upgrades expose organizations to significant risks. Lower environments don't reliably predict post-upgrade behavior if their topologies, infrastructure, and configuration aren't identical to production targets or when synthetic load profiles don't accurately mimic their real-world counterparts. What if there was a way to test your next upgrade in production—safely and repeatedly—using actual production loads? To compare the before and after performance of identical systems, side-by-side, in AWR reports? To practice and perfect the upgrade process, catching and fixing performance issues before go-live? These capabilities are available and easier to achieve than you might think. Learn how to bulletproof your next upgrade, replacing hope and luck with Data Guard Snapshot Standby and Real Application Testing! 

This session explains: 

• How to use Data Guard to protect a standby database and prepare it for upgrade
• Leverage Real Application Testing to generate and replay production workloads
• Capture database activity and preserve performance metrics for comparison
• Revert the standby database to its original state