Eclipsys Blog: Oracle Database 23ai (2)
-->Latest Posts
Oracle 23ai: Bigfile Tablespace Shrink
Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond requested RESIZE value” because there are..
Oracle 23ai: Managing Flashback Database Logs Outside the Fast Recovery Area
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23ai Database introduces the option to store flashback..
Oracle 23ai: Read-Only Users and Sessions
Overview: Oracle 23ai Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the privileges of the user that..
Oracle 23ai: Hybrid Read-Only Mode for Pluggable Databases
Overview: Oracle 23ai database introduces a new feature to open Pluggable database in a new mode called hybrid read-only Hybrid read-only mode enables a PDB to operate as either..
Oracle 23ai: INTERVAL Data Type Aggregations
Overview: Oracle 23ai introduces the use of SUM and AVG functions with INTERVAL datatype This enhancement makes it easier to calculate totals and averages over INTERVAL values In..
Oracle 23ai: Direct Joins for UPDATE and DELETE Statements
Overview: Oracle 23ai now allows you to use direct joins to other tables in UPDATE and DELETE statements in the FROM clause These other tables can limit the rows changed or be the..
Oracle Database 23c is Here!
Oracle is here with their latest version of RDBMS (Relational Database Management System) Technology – Developer edition/release. This allows Developers and DBAs (Database..
Oracle Database 19c Pre-Upgrade Checklist
Every few years, organizations face the challenge of not only upgrading their databases from long-term release versions but also eliminating as much downtime as feasible, in the..
What’s ODABR Snapshot and How to efficiently use it to Patch ODA from 18.x to 19.x
Although most of the focus, nowadays, has shifted to migration of on-premises workloads into the Cloud, companies still leverage Oracle Databases engineered systems like Oracle..
Popular Post
