Blog: Oracle Database (4)

-->

Latest Posts

Measuring Storage Performance for Oracle Database

Introduction Storage vendors often provide extensive product performance data, but this information may not accurately predict how the storage will perform with an Oracle..

Read More

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..

Read More

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..

Read More

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...

Read More

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..

Read More

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..

Read More

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..

Read More

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

Read More

ExaCC: Create a Custom Database Software Image

Overview: ExaCC users patch and provision their Oracle Database Homes using standard Oracle-published images Oracle makes the major Oracle database versions with the last 4..

Read More

Automation – Apply Database Release Update Patch in Oracle 19c using Ansible

Introduction: In this blog, I will show you how to use Ansible to automate Oracle database patching. I applied the latest Oracle 19c RU Patch “Database Release Update..

Read More