Latest Articles

DBMS_DEVELOPER Package - Database Object Metadata in JSON Format
The DBMS_DEVELOPER package was introduced in Oracle database 23ai (23.7) to return metadata about database objects in JSON format.

Smallfile Tablespace Shrink in Oracle Database 23ai (23.7)
From Oracle database 23ai (23.7) onward we can use the DBMS_SPACE package to shrink a smallfile tablespace to reclaim unused space.

Data Redaction (DBMS_REDACT) Enhancements in Oracle Database 23ai (23.6)
This article demonstrates a number of the enhancements to Data Redaction in Oracle Database 23ai (23.6).

Silent Upgrade of Oracle Enterprise Manager Cloud Control to 24ai (24.1)
This article describes a silent upgrade of Enterprise Manager Cloud Control to 24ai (24.1).

Oracle Enterprise Manager Cloud Control 24ai (24.1) Silent Installation on Oracle Linux 9
This article describes the silent installation of Oracle Enterprise Manager Cloud Control 24ai (24.1) on Oracle Linux 9.

Oracle Enterprise Manager Cloud Control 24ai (24.1) Silent Installation on Oracle Linux 8
This article describes the silent installation of Oracle Enterprise Manager Cloud Control 24ai (24.1) on Oracle Linux 8.

Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5) Silent Installation on Oracle Linux 9
This article describes the silent installation of Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5) on Oracle Linux 9.

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

 

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

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

Oracle REST Data Services (ORDS) : Oracle Database API for MongoDB
This article demonstrates the use of the Oracle database API for MongoDB functionality built into Oracle REST Data Services (ORDS).

JSON Collections in Oracle Database 23ai
Oracle database 23ai introduced JSON collections, which are specifically for use with the Oracle Database API for MongoDB and Simple Oracle Document Access (SODA).

Oracle REST Data Services (ORDS) : GraphQL
This article demonstrates the GraphQL functionality built into Oracle REST Data Services (ORDS) from version 23.3 onward.

GraphQL in Oracle Database 23ai
This article describes the GraphQL functionality introduced in Oracle Database 23ai.

AI Vector Search in Oracle Database 23ai
This article provides a simple example of using the AI Vector Search feature in Oracle database 23ai.

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.

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, ORDS 24
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)