Posts

Auto Redo Prioritization in Oracle AI Database 23.26.3: A Practical Test with OLTP and Batch Workloads

By -
Image
  Oracle AI Database 26ai introduces Auto Redo Prioritization , a new capability available from Release Update 23.26.3 that helps protect OLTP workloads during periods of heavy redo activity. When redo buffer pressure becomes critical, Oracle can identify sessions generating large amounts of redo with longer-running calls as batch-like workloads. These sessions may wait on redo prioritization for log write lag , slowing their redo generation and giving latency-sensitive OLTP transactions more room to progress. The goal is simple: protect OLTP responsiveness by automatically controlling batch-like redo generation when redo pressure builds . REDO PRESSURE │ ▼ ┌─────────────────────┐ │ Redo buffer pressure │ └──────────┬──────────┘ │ ▼ Auto Redo Prioritization │ ┌───...
Post a Comment
Read more

Installing Oracle AI Database 26ai on Oracle Linux 10

By -
Image
  Starting with Oracle AI Database 26ai Release Update 23.26.2 , the Linux x86–64 operating system is supported with the following minimum supported versions: Oracle Linux 10 with the Unbreakable Enterprise Kernel 8: 6.12.0–104.43.4.2.el10uek.x86_64 or later Oracle Linux 10 with the Red Hat Compatible Kernel: 6.12.0–55.40.1.0.1.el10_0.x86_64 or later In this article, we will walk through the installation of Oracle AI Database 26ai on Oracle Linux 10 .2. The installation process can be divided into two main parts. First, we prepare the operating system for Oracle Database by configuring the hostname, local package repository, required packages, Oracle user and groups, kernel parameters, resource limits, directories, and environment variables. In the second part, we install the Oracle Database software, apply the required Release Update (RU), execute the required root scripts, and finally create a database using Database Configuration Assistant (DBCA). 1. Preparing Oracle Linux 10 f...
Post a Comment
Read more