This blog post provides a PL/pgSQL script that utilizes pg_background extension to create and execute CPU-bound background worker processes. Also validates the CPU usage with docker stats. #Postgres #PostgreSQL #Database dincosman.com/2024/12/13/cpu…

dincosman.com/2024/12/13/cpu… This blog post provides a PL/SQL script that utilizes Oracle’s DBMS_SCHEDULER to create and execute CPU-bound jobs. It addresses constraints of the Oracle Database 23ai Free version, limiting CPU usage to two cores.

Oracle Database APEX Upgrade: 19.2 to 24.1 dincosman.com/2024/12/21/ora… via @insanedba

Moving Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in Detail dincosman.com/2025/01/03/mov… @insanedba aracılığıyla

New Blog Post: Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE dincosman.com/2025/02/09/bin… via @insanedba

Tools for Oracle Database Proactive Health Checks and Diagnostics dincosman.com/2025/02/23/ora… via @insanedba

New blog post: Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect dincosman.com/2025/03/13/clu… @insanedba aracılığıyla

Disable the Compression Advisor Without Turning Off the Segment Advisor in Oracle dincosman.com/2025/04/20/dis… via Osman DINC #Oracle #Database #Databases

Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes) dincosman.com/2025/04/26/ans… via @insanedba

DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymore... Oracle has introduced a fix (bug fix 35018026) that allows access to hashed passwords under strict conditions. dincosman.com/2025/05/02/get… via @insanedba

Oracle Hash Partitioning: Benefits and Best Practices Whether you're seeking uniform data distribution, aiming to reduce row lock waits on index segments highlighted in AWR’s "Segments by Row Lock Waits" section, then check out dincosman.com/2025/05/09/ora… via @insanedba #Oracle

New Blog Post: Part 1: NVL vs DECODE and CASE - Short Circuit Behavior While NVL employs eager evaluation, executing all arguments regardless of necessity, DECODE uses lazy evaluation. dincosman.com/2025/05/17/nvl… via @insanedba

Part 2: Scalar Subquery Caching Behavior in a SQL Statement This technique reduces redundant evaluations and recursive function calls. dincosman.com/2025/05/17/sca… via @insanedba

New Blog Post: How Oracle Changes Your SQL: Uncovering Hidden Query Transformations Query transformations and translations are some kind of magic. 👉 Read the full post here: dincosman.com/2025/05/24/hid… #Oracle #Database #SQL

New Blog Post: Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy Say goodbye to the browser, after reading this post, you'll download Oracle patches the smarter way. dincosman.com/2025/06/04/dow… #Oracle #AutoUpgrade

Oracle Database Patching with AutoUpgrade in Offline Environments DBAs may forget some post-patching tasks, but it seems that AutoUpgrade does not. dincosman.com/2025/06/14/aut… #Oracle #DatabasePatch

Is it possible to deploy an Oracle Autonomous Database on your laptop with a management interface like OCI? Yes. Here it is. dincosman.com/2025/06/18/dep… #Oracle #AutonomousDatabase #OracleATP #Docker #OracleDeveloper #DevOps #OracleCloud #DatabaseActions #ORDS #SQLcl #DB

My article "When Bind Variables Backfire" is published in ORAWORLD Issue 35 (July 2025), pages 53–58! 🔥 I explore surprising real-world issues around bind variables in Oracle Database. Read it here 👉 oraworld.org/fileadmin/docu… #Oracle #ORAWORLD #SQL #DBA #Database