Oracle Hot Topics: Febrero 28, 2025

Bugs

Bug Product Area Bug ID Last Updated
ORA-600 [KDSGRP1] IN ADG AFTER FAILOVER
Oracle Database - Enterprise Edition 22241601 Fri, 28 Feb 2025 03:53 GMT-06:00


Knowledge Articles
Knowledge Article Product Area Last Updated
Support Position for Oracle Products Running on Supported Guest OS under Oracle Linux KVM

Oracle Database Cloud Exadata Service Oracle Database - Enterprise Edition Oracle Cloud Infrastructure - Exadata Cloud Service Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) Gen 2 Exadata Cloud at Customer Wed, 26 Feb 2025 09:08 GMT-06:00

Oracle Base Database Service (BaseDB) - Clone PDB API Deprecation on Base Database Service (Base DB)

 

Action Required

Oracle Cloud Infrastructure Customer, Effective November 01, 2025, theClone PDB APIs listed below are being deprecated and replaced with new APIs. localClonePluggableDatabase RemoteClonePluggableDatabase Additionally the following FIELD will also be deprecated. dbSystemShape Action Required: Please review MOS Note KA311 - API (Clone PDB) Deprecation on Base Database Service (BaseDB for all details of the deprecation as well as learn how to perform equivalent operations. Note: If you have custom or Terraform scripts that reference the APIs and / or the FIELD mentioned above, they should be amended to reflect the changes. If you havce any queries or concerns related to this upcoming chnage, please contact Oracle Support by creating a Service Request(SR) and provide the Reference Number included in this notification. Reference Number bd581112 Action Required By November 1, 2025 00:00 UTC   Service(s) Oracle Base Database Service (BaseDB)

Oracle Hot Topics: Jan 07, 2025

Bugs
Bug Product Area Bug ID Last Updated

VARIOUS ORA-600 OR ORA-7445 IN QUERY WITH LISTAGG AND OTHER AGGREGATIONS IN 19.25

Oracle Database - Enterprise Edition 37334244 Fri, 7 Feb 2025 05:34 GMT-06:00

Knowledge Articles
Knowledge Article Product Area Last Updated

purgeLogs: Archive & Cleanup traces, logs in one command

Exadata Database Machine V2 Oracle Database Appliance Oracle Database Cloud Exadata Service Oracle Database - Enterprise Edition Real Application Clusters Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) Gen 2 Exadata Cloud at Customer Fri, 7 Feb 2025 02:06 GMT-06:0


"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support

En verdad desaparece la tabla DUAL en la versión de Oracle Database 23ai?

Una de las características más comentadas de la versión 23ai de Oracle Database, es que ahora no es necesario utilizar la famosa tabla "Dummy", que todos conocemos como "DUAL", que nos acompañó desde la versión Oracle 7 !!!.

Pero no te engañes, si activas el plan de ejecución de la sentencia, verás que la ruta de recuperación de valores, realiza un "FAST DUAL"

En versiones antiguas de Oracle (antes de 10g), la tabla DUAL era una tabla física con una única fila y columna. Sin embargo, a partir de Oracle 10g, se reemplazó con una implementación interna basada en una vista sobre X$DUAL, lo que evita accesos innecesarios a segmentos de datos.

Por eso, un plan de ejecución en Oracle 10g o versiones posteriores, mostraran un acceso "FAST DUAL", que indica que Oracle ha optimizado la consulta evitando el acceso a una tabla real y, en su lugar, genera el resultado de manera interna en la memoria, sin necesidad de realizar una operación I/O en disco.