July delivers another strong collection of technical content from across Oracle, with a particular focus on Oracle AI Database, enterprise AI, application development, and cloud technologies. This month’s resources explore everything from SQL performance and data integrity to agentic AI, durable memory architectures, Oracle Integration, MySQL, and upcoming community events. Whether you’re a developer, DBA, architect, or technology leader, there’s plenty of new content to help you build modern, intelligent applications.
Oracle AI Database & SQL
* Ensuring Data Integrity in One-to-Many Relationships
Learn how to use foreign keys and assertions in Oracle AI Database to guarantee that every parent row has at least one related child row. This approach helps enforce stronger business rules directly in the database while maintaining data integrity.
* Stop UPDATEs from Hanging Forever
Blocked DML operations can impact application performance and user experience. In this Ask TOM Live session, Chris Saxon discusses practical techniques for preventing UPDATE statements from waiting indefinitely.
Watch now: https://www.youtube.com/watch?v=COI132cifgQ
* Using the New NOWAIT Clause for DML
Discover the new [NO]WAIT clause available for INSERT, UPDATE, DELETE, and MERGE statements in Oracle AI Database. Learn how it gives developers greater control over locking behavior and concurrency.
* Why Logical I/Os Matter
SQL performance isn’t just about execution time. This Ask TOM Live session explores logical I/Os—one of the most important metrics for understanding, measuring, and tuning SQL performance.
* Autonomous AI Database: AWS KMS Support for Cross-Region Data Guard
Oracle has announced the general availability of AWS KMS support for Cross-Region Data Guard in Autonomous AI Database Dedicated on Oracle Public Cloud. This new capability enables secure disaster recovery deployments across AWS regions while allowing organizations to keep customer-managed encryption keys within their native AWS Key Management Service (KMS).
Learn more: AWS KMS Support for Cross Region Data Guard
Enterprise AI & Oracle Developers
Enterprise AI continues to evolve rapidly, and this month’s developer resources explore practical architectures, durable memory, modern AI frameworks, and Oracle AI Database as the foundation for intelligent applications.
* From RAG to Memory Systems: Building Stateful AI Architecture
Go beyond traditional retrieval-augmented generation (RAG) by learning how to design durable AI memory systems using typed memory, promotion gates, replayable traces, scoped access control, and Oracle AI Database for long-running intelligent applications.
Read more: https://blogs.oracle.com/developers/from-rag-to-memory-systems-building-stateful-ai-architecture
* Which Agent Memory Approach Is Best for Long Conversations?
Discover practical techniques for supporting long AI conversations using sliding windows, summaries, vector retrieval, structured memory, episodic memory, and intelligent memory management.
Read more: https://blogs.oracle.com/developers/which-agent-memory-approach-is-best-for-long-conversations
* The Agent Loop Decoded
Explore how modern AI agents evolve from basic tool-calling assistants into advanced systems with reasoning, memory, semantic tool discovery, context engineering, and continual learning.
* OpenAI-Compatible Endpoint for OCI Generative AI
Learn how LiteLLM provides a single OpenAI-compatible endpoint for OCI Generative AI models, making it easier to build and migrate AI applications while leveraging Oracle Cloud Infrastructure.
* Database-Enforced Authorization for Agentic AI .NET Applications
Learn how Oracle Deep Data Security and ODP.NET help protect AI-powered .NET applications from over-broad agent access, prompt injection, and tool misuse. This blog explores how database-enforced authorization can strengthen security while enabling enterprise AI applications.
Read more: https://blogs.oracle.com/developers/database-enforced-authorization-for-agentic-ai-net-applications
* Oracle AI Database Vector Store Connector for Microsoft Agent Framework
Discover how the new Oracle AI Database Vector Store Connector enables developers to build enterprise AI agents using Oracle AI Database and Microsoft’s latest Agent Framework, bringing vector search and enterprise data to modern .NET applications.
* New Oracle Developer Tools for Visual Studio, .NET AI Vector Connector, and Deep Data Security
Watch this webinar to see the latest Oracle Developer Tools for Visual Studio in action. The session covers natural language database queries, AI agent development, the new .NET AI vector connector, and Oracle Deep Data Security features for enterprise developers.
Watch more: https://www.youtube.com/watch?v=piQaQGtys14
* Building RAG Document Pipelines in Java Using LangChain4J and Oracle AI Database
See how to build enterprise-ready document ingestion pipelines with LangChain4J, using OracleDocumentLoader and OracleDocumentSplitter to prepare documents for retrieval-augmented generation applications.
* Make Your Spring AI Assistants Remember
Learn how to implement persistent chat memory for Spring AI applications using the Oracle AI Database Dialect, enabling AI assistants to retain context across conversations and deliver richer user experiences.
* AI Development with Kotlin and Oracle AI Database
Kotlin developers can explore two practical guides: one demonstrates building AI vector search applications with Exposed, Oracle JDBC, and Universal Connection Pool (UCP), while the other shows how to provide durable conversational memory for Koog-based AI agents using Oracle AI Database as the persistent backend.
Build AI Vector Search Apps: https://juarezjunior.medium.com/build-ai-vector-search-apps-in-kotlin-with-exposed-oracle-jdbc-universal-connection-pool-ucp-b72906eb4de5
Make Your Kotlin AI Agent Remember: https://juarezjunior.medium.com/make-your-kotlin-ai-agent-remember-with-koog-oracle-chat-history-provider-and-the-oracle-ai-d5e8dc330d9c
Developer Best Practices
* Blue Sky Programming: The Optimism Trap
Connor McDonald explores a common trap developers fall into when designing solutions—optimizing for an ideal future rather than today’s real business requirements. It’s a thoughtful reminder to balance innovation with practical engineering.
Read more: https://connor-mcdonald.com/2026/06/26/blue-sky-programming-the-optimism-trap/
Oracle MicroTx 26.1
Oracle MicroTx 26.1 is now generally available, introducing durable workflow orchestration, distributed transaction coordination, Oracle Database integration, and AI agent capabilities for building reliable enterprise applications.
To help you get started, explore these additional resources:
* Oracle MicroTx 26.1 Is Now Generally Available
Learn about the latest release and its new capabilities for developing resilient cloud-native applications.
Read more: https://blogs.oracle.com/database/oracle-microtx-26-1-is-now-generally-available
* When AI Agents Meet Enterprise Reality
Discover how workflows, transactions, and runtime controls come together to help organizations move AI agents from experimentation to production-ready enterprise solutions.
* Designing and Deploying Agentic Workflows with Distributed Transactions
The updated Oracle LiveLabs walks you through building and deploying agentic workflows using Oracle MicroTx’s distributed transaction capabilities.
Watch more: https://livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?wid=4243&clear=RR,180&session=6815225476894
Oracle Integration
Looking to build Agentic AI solutions with Oracle Integration? Oracle’s hands-on workshops provide practical experience with the latest AI capabilities.
Learn how to:
- Build AI-powered integrations
- Connect and govern AI agents
- Work with Large Language Models (LLMs)
- Explore Intelligent Expense Automation with Oracle Integration
Sessions are available across multiple regions throughout July, August, September, and October.
Integration Resources:
- https://blogs.oracle.com/soacommunity/links
- June Edition Oracle Integration Partner Community Newsletter #231
You can also explore Oracle LiveLabs on demand to start building with Oracle Integration at your own pace:
- Get Started with Oracle Integration 3
- Oracle Integration 3 – Automate Invoice Processing with OCI Document Understanding
MySQL Updates
July brings exciting news for the MySQL community, with major announcements focused on openness, collaboration, and long-term innovation.
Highlights include:
- The Next Phase of MySQL Community Engagement explores Oracle’s vision for accelerating community participation and collaboration.
- Opening Up the MySQL Bug Process introduces greater transparency and community involvement in reporting and resolving issues.
- MySQL 9.7 LTS Is Here marks the arrival of the latest Long-Term Support release, providing a strong foundation for developers and database administrators.
Looking to connect with the MySQL team? Find conferences, user group meetings, and community events happening throughout the summer.
Explore MySQL resources: https://blogs.oracle.com/mysql
Community Spotlight
* Sangam 2026 (July)
Join Oracle speakers including Sandesh Rao, Connor McDonald, Mike Dietrich, Markus Michalewicz, alongside speakers from Microsoft and Google, as well as Oracle ACE Directors, at Sangam India.
Learn more: https://www.aioug.org/sangam26
* Latin America Tour (August)
Oracle experts, including Markus Michalewicz, Jayson Hanes, Connor McDonald, and Oracle ACE Directors, will be participating in the Latin America Tour, delivering technical sessions throughout the region.
Learn more: https://www.laouc.org/
Whether you’re exploring Oracle AI Database, building intelligent applications, modernizing enterprise architectures, or connecting with the Oracle community, July offers a wealth of new technical resources to help you stay informed and inspired. Be sure to bookmark these articles and check back next month for another edition of the Monthly Product Pulse.