Latest Articles

Bigfile Tablespace Shrink in Oracle Database 23ai
From Oracle database 23ai onward we can use the DBMS_SPACE package to shrink a bigfile tablespace to reclaim unused space.

Bigfile Tablespace Defaults in Oracle Database 23ai
Bigfile tablespaces were introduced in Oracle 10g. In Oracle database 23ai bigfile tablespaces are the default.

JSON_BEHAVIOR Parameter in Oracle Database 23ai
By default many JSON functions return null if they encounter a runtime error. Oracle database 23ai introduced the JSON_BEHAVIOR parameter to allow us to alter this default behaviour for our session.

EMPTY STRING ON NULL for JSON Generation in Oracle Database 23ai
Oracle database 23ai has introduced the ability to convert nulls to empty strings during JSON generation.

Oracle Database 21c Installation On Fedora 40 (F40)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 40 (F40).

Oracle Database 19c Installation On Fedora 40 (F40)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 40 (F40).

Fedora 40 (F40) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 40 (F40).

Oracle Database 23ai Free RPM Installation On Oracle Linux 9 (OL9)
This article describes the RPM installation of Oracle Database 23ai Free 64-bit on Oracle Linux 9 (OL9) 64-bit.

 

Staging Tables in Oracle Database 23ai
Oracle database 23ai introduces the FOR STAGING clause in the CREATE TABLE command to create a variation of heap tables, which have optimal configuration for fast data ingestion.

TLS and Wallet Enhancements in Oracle Database 23ai
Oracle 23ai includes several enhancements to Transport Layer Security (TLS) and wallets, simplifying configuration, and making the database more secure.

SQL*Plus New Features in Oracle Database 23ai
This article describes the new features of SQL*Plus in Oracle Database 23ai.

Loading JSON Data using External Tables in Oracle Database 23ai
In Oracle database 23ai loading JSON data using external tables got much simpler.

Oracle Database 21c Installation On Fedora 39 (F39)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 39 (F39).

Oracle Database 19c Installation On Fedora 39 (F39)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 39 (F39).

Fedora 39 (F39) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 39 (F39).

Oracle Database 19c RAC On Oracle Linux 9 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 19c RAC on Oracle Linux 9 using VirtualBox and Vagrant with no additional shared disk devices.

Latest Videos

Check out my YouTube channel here.

• Data Pump LOGTIME
• Data Pump Checksums in Oracle Database 21c
• RANK and DENSE_RANK Aggregate Functions
• SQLcl : Data Pump (Part 2)
• Ansible Playbooks : Vault
• Ansible Playbooks : Roles
• Ansible Playbooks : Users and Groups
• Ansible Playbooks : Tags

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:

• Twitter/X (@oraclebase)
• LinkedIn
• YouTube
• Facebook
• GitHub
• Mastodon (@oraclebase@techhub.social)
• Bluesky (@oraclebase.bsky.social)
• Threads
• Linktree

Oracle Documentation

12cR1, 12cR2, 18c, 19c, 21c, 23ai
ORDS 19, ORDS 20, ORDS 21, ORDS 22, ORDS 23
APEX 22.1, APEX 22.2, APEX 23.1, APEX Old Releases
ADW, ATP
EM 13c, Middleware, 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, ORAdiff,
Release Schedule of Current Database Releases (Doc ID 742060.1)