I’m pleased to share all my cloud posts on this page. As with all the other pages, posts are in chronological order.
Quick tip concerning dbms_cloud’s create_credential() call
DBMS_CLOUD is one of the crucial packages in Oracle AI Autonomous Database (ADB from now on). It allows you to perform many operations, including the creation of credentials. These are almost universally required for developers and admins alike. DBMS_CLOUD.CREATE_CREDENTIAL is an overloaded procedure, its documentation can be found here. I recently experimented with Select AI,…
JavaScript showcase: a fun playground environment for MLE/JavaScript in Oracle AI Database 26ai
I’m a huge fan of Oracle’s SQL Developer Extension for VSCode. I use it on a daily basis, and it has been invaluable to me. I particularly like the great integration into Git, and it’s built on top of a solid foundation that is Visual Studio Code. Recently I found out about GitHub CodeSpaces. After…
Why does my query run in parallel on Autonomous Database-Serverless even though I do everything to prevent it from doing so?
While preparing for another blog post I desperately wanted to write I noticed something unexpected. The problem turned out to be between keyboard and chair, but I don’t want to get ahead of myself. Tell me what happened already! Using Oracle SQL Developer Extension for Visual Studio Code, connecting to an Autonomous Database-Serverless, a query…
Using Oracle Database Free in your devcontainer and GitHub Codespaces
Dev containers are pretty nifty when it comes to keeping your development environment isolated from the rest of your system. Quoting from the documentation: Development containers, or dev containers, are Docker containers that are specifically configured to provide a fully featured development environment. Whenever you work in a codespace, you are using a dev container…
Using Ansible to resize the root LV on Oracle Linux 9 in OCI
While preparing an upcoming talk at a community event I worked on some Terraform code I recycled. In a nutshell, I’m creating a virtual machine in Oracle Cloud Infrastructure using Oracle Linux 9. I’m fully intending to run Oracle Database 19.28.0 on that VM later. Rather than sticking with the default boot volume size I…
Identify driver details of your cloud VM’s block devices
While preparing a presentation for POUG 2025 I had a need to find out more about the block device driver in use on my system. I was particularly interested in the SCSI mid-layer and low-layer drivers. Unsure about these terms? I am referring to the Linux Storage Stack Diagram. It’s a great resource for anyone…
Oracle Cloud Infrastructure: establish a console connection to a Windows compute VM
You may occasionally run into issues with a Windows 2022 (or later) compute VM in Oracle Cloud Infrastructure (OCI) that require you to access the VM via the graphical recovery console. This article describes how to connect to a graphical recovery console, based on VNC using MacOS 15.3 Sequoia. The latest MacOS 15.3 ships with OpenSSH_9.8p1/LibreSSL 3.3.6. It…
Use Flashback Time Travel with Autonomous Database
This is a very short post, mainly for my own benefit, to summarise how to use Flashback Time Travel (previously named Flashback Data Archive or Total Recall) in Autonomous Database 23ai – Serverless (ADB-S from now on). At the time of writing the database was patched to Release Update 7: SQL> select 2 version_full 3…
Containers are awesome, not only for stateless things
This post describes why using containers, even for database driven applications, is very useful.
Something went wrong. Please refresh the page and/or try again.
Martins Blog 