23ai New Database Object: Application Usage Domains
January 22, 2025To help application development with data consistency and data quality, a new database object type was introduced with 23c and… Continue Reading
Meet Your New Friend: DBMS_SPACE.SHRINK_TABLESPACE
September 30, 2024How many times did you try to resize your tablespace or datafile and got the error “ORA-03297: file contains used… Continue Reading
23ai New Feature: GRANT SELECT ANY TABLE ON SCHEMA
May 20, 2024Another 23c or 23ai feature that you will be happy embracing!In previous Oracle versions, what did you do when someone… Continue Reading
![23ai New Feature: How To Use IF [NOT] EXISTS in DDL Statements](https://dbaparadise.com/wp-content/uploads/2024/05/2024-05-11-23cNewFeature-IF-EXISTS-DDL-cover-540x304.jpg)
23ai New Feature: How To Use IF [NOT] EXISTS in DDL Statements
May 12, 2024A new feature was introduced with 23c, now 23ai, that can help you with object creation or object drop. This… Continue Reading
23c New Feature – Alias in the GROUP BY Clause?
January 31, 2024You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP… Continue Reading
Is the FROM Clause Really Optional?
December 15, 2023Did you know that starting with Oracle 23c, the FROM clause is optional? Not totally optional, so let me explain.… Continue Reading
What Are Annotations and How to Use Them in Oracle 23c?
November 26, 2023One of the new features of the Oracle 23c is annotations. These were mostly created for developers, but I can… Continue Reading
4 Steps to Spring Clean Your Databases
March 28, 2023It’s spring time, and that comes with spring cleaning not only your house and closets, but your databases too! What… Continue Reading
How Many Processes In the Database Historically?
March 23, 2023The other day, I had an interesting challenge to look at. The maximum number of processes in the database instance… Continue Reading
4 Ways of Connecting to a PDB
February 26, 2023How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We… Continue Reading