Eclipsys Blog: Oracle Database (2)
-->Latest Posts
Exadata Exascale and What it Means for Your Oracle Workloads
Last week, Oracle Exadata Exascale was released, and it is one of the features that I have been most excited about in a while. I will be writing a couple of blogs around the..
Oracle Database 23ai: Fetch Top-N Rows Per Group Queries
Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..
Oracle 23ai: JSON Schema Support
Overview: Oracle first introduced the ability to display a JSON schema when they introduced the JSON Data in Oracle 12.2 but without the option to validate the structure of JSON..
ODA Bare Metal Patching From 19.16 to 19.20
ODA Upgrade from 19.16 to 19.20 Patching Oracle Database Appliance (ODA) Bare Metal Systems involves applying updates to both the operating system and Oracle Software Components...
Strengthening Database Security with Oracle Data Safe
Protecting sensitive information is always important. Nowadays, with a greater and greater risk of attack, safeguarding sensitive data is a top priority for all organizations,..
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: 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..
Troubleshooting Oracle Database Environments: Navigating Through inventory.xml Corruption Issues
Encountering errors can often lead us down a rabbit hole of troubleshooting and investigative work. Recently, a scenario encountered highlighted the critical importance of..
ADB App Store – Oracle Autonomous Database App Store and How to Deploy Application
The ADB App Store: This is an application launchpad for Oracle-supported applications. Using the ADB app store, tenants can install and manage the life cycle of these applications
What Autoupgrade Won’t Catch for You when Moving to 19c Part1: Ghost OLAP
Introduction So far, I have used Oracle AutoUpgrade, many times in 3 different OS’. Yet the more you think you’ve seen it all and reached the highest confidence level, another..
Popular Post
