📰 More good reasons to use bind variables in cursors in Oracle - Martin Bach explains what bind variables are and why you should be using them 📰 🤖 Natural Language SQL with Oracle MCP and LangChain4j - Anders Swanson shows how you can build agentic applications with MCP, Oracle Database and Langchain4j 📰 🤖 Can I build an Agent & still use SQLcl’s MCP Server?

📰 How Oracle 23ai Fixes Bad Plans Instantly.. A Live Demo of Real-Time SPM - Prashant Dixit dives into Oracle 23ai SQL Plan Management 📰 Do Not Put Security Checks in an Oracle BEGIN END block - Pete Finnigan shows why you shouldn't put hard-coded security checks into PL/SQL BEGIN/END blocks but rely on Oracle's built-in security functionality 📰 Creating column-level annotations on views…

For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again!…

The Oracle Database is one of the most robust and feature-rich databases available. Naturally, its documentation is vast and frequently updated. Navigating through thousands of pages to find the right information can be time-consuming, even for experienced users. And in the advent of AI, who wants to search the documentation manually for clues anyway? That's where the brand new Oracle Database Documentation MCP server…

📰 🤖 OML4Py 2.1 on Linux - Øyvind Isene uses OML4Py to export embedding models into ONNX format 📰 Using the MLE PL/SQL Foreign Function Interface in APEX - Martin Bach shows how to use PL/SQL inside JavaScript Stored Procedures 🏆 ONC Certification of Oracle’s AI-Powered EHR Marks Turning Point for the Healthcare Industry - Oracle Health’s next-generation electronic health record (EHR) is now certified and ready for adoption by ambulatory customers in the U.S…

This post originates from some discussions and conversations I have had and overheard in the last couple of months. It’s about storage and the fact that people have forgotten how much data a …

If you've ever hit that dreaded No space left on device error mid-build in your GitHub Actions workflow, you're not alone. GitHub Actions is a powerhouse for CI/CD, but the hosted runners it uses come with finite resources—especially disk space. As your projects grow (think massive Docker builds, hefty node_modules, or sprawling test suites), that space can evaporate faster than a bad pull request.

📰 New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity - Tanel Poder continues his quest for useful SQL scripts, this time for showing system/OS metrics 📰 Behind the Scenes: Oracle’s Data-Driven Journey to Faster, Automated Cloud Builds - Oracle explains how OCI is conducting rapid Region Builds thanks to creative data analytics strategies 📰 Designing Transit Routing in Oracle Cloud Infrastructure (Part II)

For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again! This release has quite a broad spectrum of new features, some of which are near and dear to everyday developers, such as the SQL QUALIFY clause, and some of them help venture into new(er) avenues, such as GraphQL support.

📰 xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) - Tanel Poder explains the importance of row-count estimates and shares some useful scripts 📺 Installing Oracle Linux 10 - Oracle Learning demonstrates how to install Oracle Linux 10 📰 🤖 In-database AI inference on Oracle Active Data Guard: A practical walkthrough - Ludovico Caldara offloads AI inference workloads into Active Data Guard standby instances without the need for CQRS…

Previously on @thatjeffsmith... Oracle Database 23ai Free 23.5, now avail for VirtualBox

Oracle AI Database 23.26.0 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.8 images have now gone into Unsupported. See the support matrix for more information.

📰 Surviving Regional and DNS Failures in the Cloud - Sinan Petrus Toma and Markus Michalewicz explain strategies to compensate for widespread cloud provider outages 📰 How I Think You Should Create Your Container Databases - Daniel Overby Hansen demonstrates best practices for creating new Oracle container databases 📰 What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 1…

📰 How to write a custom tracer for Oracle Database JDBC - Anders Swanson demonstrates the new Oracle Database JDBC OpenTelemetry provider capabilities 📰 tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates - Tanel Poder has a new script for Oracle Database hybrid histograms 📰 Using Oracle Database Free in your devcontainer and GitHub Codespaces - Martin Bach shows you how to use Oracle Database Free in GitHub Codespaces…