8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Latest Articles

TLS and Wallet Enhancements in Oracle Database 23c
Oracle 23c 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 23c
This article describes the new features of SQL*Plus in Oracle Database 23c.

Loading JSON Data using External Tables in Oracle Database 23c
In Oracle database 23c 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.

Oracle Database 19c Installation On Oracle Linux 9 (OL9)
This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 9 (OL9) 64-bit.

 

Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23c
In previous releases making HTTPS callouts from the database required the use of a client wallet. From Oracle database 23c onward we can use the operating system certificate store instead.

Enhanced Partitioning Metadata in Oracle Database 23c
Oracle database 23c makes it easier to display the high value of partitions using two new columns in the ALL_TAB_PARTITIONS view.

Hybrid Partitioned Table Enhancements in Oracle Database 23c
This article demonstrates hybrid partitioned tables with interval and auto-list partitioning in Oracle Database 23c.

Materialized View Enhancements in Oracle Database 23c
This post introduces some of the materialized view enhancements in Oracle database 23c.

Logical Partition Change Tracking (LPCT) for Materialized Views in Oracle Database 23c
In Oracle database 23c Logical Partition Change Tracking (LPCT) allows materialized view staleness to be tracked at the level of a logical partition.

Materialized View Concurrent Refreshes in Oracle Database 23c
In Oracle 23c materialized view refreshes can be performed concurrently for on-commit fast refreshes by adding the ENABLE CONCURRENT REFRESH clause.

Materialized View Support for ANSI Joins in Oracle Database 23c
In Oracle 23c materialized views support query rewrites for SQL statements using ANSI or Oracle style joins.

DBMS_HCHECK in Oracle Database 23c
In Oracle 23c the DBMS_HCHECK package allows us to check for known data dictionary problems in the database.