CMCarla Muñoz Lópezinselectfromdual.comEl lado oscuro del DRM en Oracle RAC: Micro-cortes y el evento 'gcs drm freeze'En un entorno Oracle RAC, la "magia" de la coherencia de caché tiene un precio. Hoy analizaré un caso real (los que me gustan!) donde el mecanismo de Dynamic Remastering (DRM) causó un micro-delay de 3d ago·10 min read
CMCarla Muñoz Lópezinselectfromdual.comCómo Crear un Recurso de Clúster en Oracle para Ejecutar SQL de forma persistenteEn entornos Oracle RAC (Real Application Clusters), a veces necesitamos ejecutar procesos de monitorización o mantenimiento que estén vinculados a la base de datos, que puedan moverse entre nodos, parFeb 20·12 min read
CMCarla Muñoz Lópezinselectfromdual.comFragmentación por splits en índices B-tree: análisis práctico en Oracle 19cAnalizando un índice B-tree en una tabla que recibe únicamente INSERTs encuentro que la volumetría de éste es similar a la volumetría de la tabla. select sum(bytes/1024/1024/1024) Gb from dba_segments where segment_name='TABLA'; GB ---------...Feb 18·8 min read
WSWojciech Sowainwsowa.hashnode.devThe Likely Obvious Oracle Tip #9Among the many new improvements introduced with Oracle Database 23/26ai, the new capabilities of the GROUP BY clause caught my attention. In short, GROUP BY has become more flexible in terms of available syntax, matching ORDER BY in this regard. Star...Feb 17·2 min read
MMichaelinmmuehlbeyer.hashnode.devupgrade your database to 26ai using autoupgradeAs we know the non multi-tenant option is desupported Doc link in Oracle 26ai and so we have to switch to multinenant architecture when upgrading to 26ai. in Oracle 26ai and so we have to switch to multinenant architecture when upgrading to 26ai. In ...Feb 16·5 min read
JVJochen Van den Bosscheinblog.jochenvandenbossche.devOracle 26ai insert into select returningIn the 21c SQL Language Reference the following can be found regarding the INSERT statement: But in the 26ai SQL Language Reference that becomes and that small change opens a world of opportunity, reducing the number of context switches in certain ...Feb 15·4 min read
HRHassan Razainhassan-cafe.hashnode.devHow I Built a Smart Task Tracker in Oracle APEX Without Opening Each RowSo here's the thing - I was working on a project management app in Oracle APEX where users needed to mark workflow tasks as complete. simple enough, right? Well, the original design had users clicking each task, opening a dialog, clicking 'mark as do...Feb 13·5 min read
CCCristhian Cano Bogadoinparaguayandev.comBanner de Entorno en APEX y como configurarlo.Trabajar con múltiples entornos en Oracle APEX —como DEV, TEST, UAT y PROD— puede volverse un desafío incluso para desarrolladores experimentados. Cambiar entre URLs similares y realizar pruebas en el entorno incorrecto es más común de lo que quisiér...Feb 11·3 min read
PNPratik N Borkarinblog.pratiknborkar.comImplementing Dual-Stack (IPv4 & IPv6) in Oracle Kubernetes Engine (OKE): Pod Networking and Traffic Flow ExplainedAs IPv4 exhaustion becomes increasingly real, dual-stack Kubernetes is no longer just an experiment it’s a strategic decision. Recently, I implemented and validated a dual-stack cluster in Oracle Kubernetes Engine on Oracle Cloud Infrastructure, and ...Feb 11·4 min read
SKSatish Kumarinsatishkumar.hashnode.devFrom CLI to Web UI: VBCS Documentation Generator - Web UI DemoIn my previous post, Automating VBCS Documentation with AI – A Node.js CLI Tool,I walked through a command-line utility built to generate documentation for Oracle VBCS applications using AI. That tool proved one thing very clearly: AI can dramatical...Feb 11·1 min read
