Latest Articles
Oracle Cloud : Autonomous JSON Database (AJD) - Create Service
This article provides a run through of creating a new Autonomous JSON Database (AJD) service on the Oracle Cloud.
SQLcl : Simple Oracle Document Access (SODA) for SQLcl
This article gives an overview of the integration of Simple Oracle Document Access (SODA) in SQLcl.
Real-Time Statistics in Oracle Database 19c
Oracle database 19c introduced real-time statistics to reduce the chances that stale statistics will adversely affect optimizer decisions when generating execution plans.
Liquibase and Source Control : Changes to Scripts Over Time
A discussion of how to manage changes to scripts over time with Liquibase.
SQL Quarantine in Oracle Database 19c
Oracle Database 19c introduced an extension of Runaway Query Management called SQL Quarantine.
Oracle Databases and CI/CD Pipelines
This article contains a general discussion about how Oracle Databases can fit into CI/CD pipelines.
SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase
This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase.
Hybrid Partitioned Tables in Oracle Database 19c
This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c.
Liquibase : Deploying Oracle Application Express (APEX) Applications
This article demonstrates how to deploy Oracle Application Express (APEX) applications using Liquibase.
APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns.
The APEX_DATA_PARSER package allows you to easily convert simple CSV, JSON, XML and XLSX data into rows and columns from SQL.
Podman : Generate and Play Kubernetes YAML Files
Podman can generate Kubernetes YAML files from existing pod definitions, and use the generated YAML files to fire up new pods.
Oracle Database 19c RAC On Oracle Linux 8 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 19c RAC on Oracle Linux 8 using VirtualBox and Vagrant with no additional shared disk devices.
Oracle Database 19c Installation On Fedora 32 (F32)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 32 (F32).
Fedora 32 (F32) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 32 (F32).
Podman : A Basic Example of Using Podman With Dockerfiles (Oracle Database and ORDS) on Oracle Linux 8 (OL8)
This articles shows how to use Podman with existing Dockerfiles as a replacement for Docker on Oracle Linux 8 (OL8).
Podman : Install Podman on Oracle Linux 8 (OL8)
We can think of Podman as a replacement for Docker, with an almost identical syntax. This article demonstrates how to install Podman on Oracle Linux 8 (OL8).
Latest Videos
Check out my YouTube channel here.
- Multitenant : Dynamic CPU Scaling
- Instance Caging to Manage CPU Usage
- Simple Oracle Document Access (SODA) for SQLcl
- Simple Oracle Document Access (SODA) for PL/SQL
- Simple Oracle Document Access (SODA) for REST
- Real-Time Statistics in Oracle Database 19c
- Online Statistics Gathering for Bulk Loads
Quick Links
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker/Container Articles
- Writing Tips
- Public Speaking Tips
- Learning New Things
- What Employers Want
- Why Automation Matters
You can follow me on these networks:
You can get an oracle-base.com t-shirt here.
Oracle Documentation
8iR3,
9iR1,
9iR2
10gR1,
10gR2,
11gR1,
11gR2
12cR1,
12cR2,
18c,
19c,
20c
ORDS 3.0,
ORDS 17,
ORDS 18,
ORDS 19,
ORDS 20
EM 10g,
EM 11g,
EM 12c,
EM 13c
ADW,
ATP
AS10g R2,
AS10g R3,
FMW 11gR1,
FMW 12cR1,
FMW 12cR2
Oracle VM,
VirtualBox
Oracle Resources
Oracle Developer Community, Technology Network, Oracle Support, Oracle Certification, Oracle Magazine, Ask Tom, Products, Downloads, Documentation, Forums, VirtualBox, VirtualBox Developer VMs, CPUs/PSUs/BPs/RUs/RURs