Oracle 23ai New Features Part 2 (Oct 2024)

OS Environment : Oracle Linux 8.4 (64bit)

 

DB Environment : Oracle Database 23.5.0.24.07 ai for Oracle Cloud and Engineered Systems

 

Title : Oracle 23ai New Features Part 2 (Oct 2024)

I'm sharing the presentation materials from the Oracle 23ai new features Part 2 seminar held in June 2024.

202410_Oracle_23ai_NF_Part2_eng.pdf

12.50MB

 

*This document has been translated from Korean to English, so the translation may not be perfectly smooth. 
I appreciate your understanding.

 

 

Index

1. Introduction to Oracle 23ai
2. Oracle 23ai Key New Features Part 2
Developer Role
Schema Annotations
SQL Domain
Staging Tables
Bigfile Tablespace Shrink
SQL Statement Tracking with SQL History
Schema Level Privilege
Table and Partition Access Tracking
Unified Memory Management
Automatic PL/SQL to SQL Transpiler
Unrestricted Parallel DMLs
Unrestricted Direct Loads
Lock-Free Reservations
Priority Transactions
3. Minor New Features
System Default Tablespace Bigfile
10046 trace
Improvement of Query Block Registry among XPLAN results
LOAD_METHOD, LOAD_TYPE hint
SQLPLUS History function
4. Oracle 23ai Free on Docker
5. Oracle ADB SELECT AI

 

 

Reference : 

Oracle 23ai New Features Summary ( https://positivemh.tistory.com/1103 )

Oracle 23ai New Features Part 1 (June 2024) ( https://positivemh.tistory.com/1184 )