The Highlights of 23c new Features

Introduction

With literally hundreds of new features introduced to Oracle version 23c, it is difficult to know which ones to cover. Below is my attempt to cover some of my favourites. Over the coming weeks I will try to cover each one in more depth and maybe even add to the list as those hidden gems appear in real-life usage.

New Fatures

Schema Level Privileges
You can now grant system privileges on a schemas. For example, you can grant CREATE ANY TABLE to a user for a given schema. With this permission, the user can create any table in the specified schema.
click for more info

Developer Role
A new role called DB_DEVELOPER_ROLE has been introduced that provides a developer with all the required privileges to build and deploy and application. (And of course debug it!!)
click for more info

Database Health Check PL/SQL
A package called DBMS_DICTIONARY_CHECK is a new PL/SQL package that can be used to identify inconsistency issues with the database data dictionary. We all know this shouldn't happen, but well, sometimes it just does. This package will help find and diagnose them.
click for more info

In-Built SQL Firewall
23c Introduces a SQL firewall that will protect you in real-time from unauthorised SQL attack.
click for more info

Object Annotations
23c Introduces a concept of object annotations. You can now annotate columns, tables, views, indexes and other objects with useful metadata. They can be name-value pairs or just a name and can help customise application logic.
click for more info

JSON-Relational Duality Views
These are fully updatable views where data is stored in underlying relational tables, but can be accessed as JSON documents.
click for more info

Cloud Pre-migration Advisor Tool
This tool checks your on-premise database to see if it is suitable to migrate to the Oracle Cloud. The tool will NOT migrate your database but will help identify issues in your database that will or could cause issues during migration. Sorry you still have to do the hard work, but this will help in that task.
click for more info

Flashback Database Logs Outside the Fast Recovery Area
As an operation DBA this has got to be favourites. You can now define a separate location for flashback logs. They no longer need to be stored in the fast recovery area. No more sleepless nights managing space in the FRA? Maybe.
click for more info

Enhanced Query History Tracking and Reporting
The query tracking has been enhanced for 23c giving greater insights and capability in tracking user initiated queries.
click for more info

Refreshable PDBs in DBCA
Using the DBCA utility you can now clone a remote Pluggable database (PDB) as a refreshable PDB. A refreshable PDB will be kept up to date with the changes in the source PDB. The changes are captured at the source and propagated over time to the refreshable PDB depending if it is configured to automatically refresh or manually refresh.
click for more info

Run a Select Statement without a From Clause
Select statements can now be un without a from clause. If you are migrating to Oracle from other databases this can help in the migration process.
click for more info

Wide Tables
Number of columns increased to 4996. I never thought I would use this. And then I did!!!
click for more info

Automatic Transaction Rollback
Configuring transactions to be automatically rolled back if blocking a higher priority transaction.
click for more info

23c Process Architecture
The latest architecture diagrams for Oracle 23c. Covering the SGA and PGA along with details of some of the new process introduced in Oracle 23c.
click for more info


Published 31st May 2023

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License