DGDominik Grabińskiindgrabinski.hashnode.devThe APEX Chainsaw Massacre! #2 How (NOT) to do something in Oracle APEX and Oracle DBWelcome to part 2 of the series on how to do, or rather, NOT do development in Oracle APEX and Oracle databases. I invite you to admire the developers' wild imagination: How to center region in APEX? 20h ago·3 min read
MMichaelinmmuehlbeyer.hashnode.devDBMS_METADATA.GET_DDL not returning password hashes Today I've stumbled over a new behaviour Oracle introduced for function DBMS_METADATA.GET_DDL. Starting with Datapump Bundle Patch 19.17 (which includes fix for bug 33517865), Oracle introduced an imp1d ago·2 min read
DGDominik Grabińskiindgrabinski.hashnode.devThe APEX Chainsaw Massacre! #1 How (NOT) to do something in Oracle AEPX and Oracle DBI invite you to a series that inspired me to prepare presentations for conferences such as Kscope, POUG, DOAG, OUGN and many more. In this series, I'll show you how to develop, and especially how NOT 2d ago·3 min read
DGDominik Grabińskiindgrabinski.hashnode.devHow to use Tabs Container in DA e.g. to show/hide region - Dominik's Tips and Tricks in APEX#4 (in short DTaTiA#4 🤷♂️)Have you ever wanted to trigger an action further down the page with a dynamic action when you click a Tab in the Tabs Container? If so, stay a while and listen ;) What was the business case for this 5d ago·3 min read
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 Feb 24·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
