Osman DINC - InsaneDBA
LightNews LightNews
banner
osmandinc.bsky.social
Osman DINC - InsaneDBA
@osmandinc.bsky.social
96 followers 410 following 31 posts
I love and tame databases and share my knowledge on https://dincosman.com/
Posts Replies Media Videos
osmandinc.bsky.social
Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool.

dincosman.com/2025/11/09/b...

#Oracle #RMAN #Database #BackupAndRecovery
Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool
This content discusses simulating tape backups using RMAN and a dummy SBT library (oracle.disksbt) to troubleshoot backup failures. The article details how to perform fake tape backups with Oracle’…
dincosman.com
November 9, 2025 at 12:37 PM
osmandinc.bsky.social
Ping Checks Life, tnsping Checks Purpose #JoelKallmanDay
#Oracle

dincosman.com/2025/10/15/p...
Ping Checks Life, tnsping Checks Purpose #JoelKallmanDay
The content explains various Oracle connectivity testing utilities: ping, tnsping, ociping, connping, and adbping. It honors Joel Kallman, a key figure in database development. The document details…
dincosman.com
October 15, 2025 at 9:16 AM
osmandinc.bsky.social
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 👉 www.oraworld.org/fileadmin/do...

#Oracle #Database #ORAWORLD
July 7, 2025 at 9:04 AM
osmandinc.bsky.social
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/d...

#Oracle #AutonomousDatabase #OracleATP #Docker #OracleDeveloper #DevOps #OracleCloud #DatabaseActions #ORDS #SQLcl #DB
Deploy Oracle Autonomous Database on your Computer
Oracle Autonomous Database can be deployed locally on a laptop using container platforms such as Docker or Podman, offering features similar to those available in the Oracle Cloud Infrastructure (O…
dincosman.com
June 19, 2025 at 5:56 AM
osmandinc.bsky.social
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/a...
Oracle Database Patching with AutoUpgrade in Offline Environments
This post illustrates how to use AutoUpgrade to patch an Oracle Database to in environments without internet access, making it also suitable for isolated systems. It details steps such as creating …
dincosman.com
June 15, 2025 at 11:57 AM
osmandinc.bsky.social
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/d...

#Oracle #AutoUpgrade
Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy
In this blog post, I walk you through how to download Oracle patches using AutoUpgrade on a Windows host behind a proxy requiring authentication. The steps include configuring proxy environment var…
dincosman.com
June 8, 2025 at 2:07 PM
osmandinc.bsky.social
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/h...

#Oracle
May 25, 2025 at 11:29 AM
osmandinc.bsky.social
Oracle 23ai Update – VKTM process is now TIME!

#Oracle
May 23, 2025 at 1:59 PM
osmandinc.bsky.social
New Blog Post : Part 1: NVL vs DECODE and CASE - Short Circuit Behavior

dincosman.com/2025/05/17/n...
#Oracle #Database #SQL #NVLvsDECODE
Part 1: NVL vs DECODE and CASE – Short Circuit Behavior
The blog post discusses the behaviors of Oracle’s NVL and DECODE functions regarding NULL values. While NVL employs eager evaluation, executing all arguments regardless of necessity, DECODE u…
dincosman.com
May 18, 2025 at 12:52 PM
osmandinc.bsky.social
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/o...
#Oracle #Database #HashPartition
Oracle Hash Partitioning: Benefits and Best Practices
Hash partitioning enhances database management and performance by evenly distributing data across partitions, crucial for handling high concurrency. However, choosing an appropriate partition key i…
dincosman.com
May 11, 2025 at 6:05 PM
osmandinc.bsky.social
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/g...

#SQL #Oracle #Database
DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymore
Recent Oracle Data Pump patches (19.17 and later — involving bug fix 33517865) have modified the behavior of DBMS_METADATA.GET_DDL, removing hashed passwords from its output as a security enhanceme…
dincosman.com
May 2, 2025 at 12:23 PM
osmandinc.bsky.social
Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes) dincosman.com/2025/04/26/a...

#Oracle #Database #Databases #Ansible #DatabasePatching
Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes)
In this post, I’m sharing the latest Ansible playbooks for patching Oracle Database and Grid Infrastructure, specifically for the Oracle 19.26 Release Update, including MRPs and recommended one-off…
dincosman.com
April 27, 2025 at 11:57 AM
osmandinc.bsky.social
Ever wondered What happens when a SQL statement has conflicting hint directives from SQL Profile, SQL Plan Baseline, and SQL Patch?

In my test case, All three whispers different things to optimizer. What will optimizer do?

I answer this.
dincosman.com/2025/04/10/s...

#Oracle #SQL #Database
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases
This content highlights the importance of stability in database performance, especially regarding Oracle’s SQL execution plans, which can fluctuate based on various factors. It focuses on three pri…
dincosman.com
April 13, 2025 at 12:54 PM
osmandinc.bsky.social
New blog post:

Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect dincosman.com/2025/03/13/c...
Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect
This post discusses a perplexing issue with node evictions in an Oracle RAC setup, where node crashes occurred due to a loss of connection on a private interconnect despite redundancy. It highlight…
dincosman.com
March 16, 2025 at 1:00 PM
osmandinc.bsky.social
New Blog Post:
Tools for Oracle Database Proactive Health Checks and Diagnostics dincosman.com/2025/02/23/o...
Tools for Oracle Database Proactive Health Checks and Diagnostics
The content discusses essential tools and scripts for monitoring Oracle Database Health, emphasizing the importance of proactive health checks to prevent performance issues. It introduces various t…
dincosman.com
February 23, 2025 at 12:53 PM
osmandinc.bsky.social
Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE dincosman.com/2025/02/09/b...
Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE
Bind variables improve SQL performance and security by reusing execution plans, reducing hard parsing overhead and mitigating SQL injection risks. However, key information can be hidden from the op…
dincosman.com
February 9, 2025 at 2:18 PM
osmandinc.bsky.social
New blog post: A Tale of Terabytes, Moving Thousands of Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in Detail dincosman.com/2025/01/03/m...
Moving Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in Detail
The post discusses the process of reorganizing and moving nearly 50,000 database objects across tablespaces within an Oracle database. It highlights the challenges posed by inconsistent storage pra…
dincosman.com
January 5, 2025 at 12:35 PM
osmandinc.bsky.social
Oracle Database APEX Upgrade: 19.2 to 24.1 dincosman.com/2024/12/21/o...
Oracle Database APEX Upgrade: 19.2 to 24.1
This post outlines the process for upgrading Oracle Application Express (APEX) from version 19.2 to 24.1. APEX is a low-code platform for developing web applications with Oracle Database. The upgra…
dincosman.com
December 21, 2024 at 3:01 PM
osmandinc.bsky.social
New blog post.
dincosman.com/2024/12/13/c...

This blog post provides a PL/SQL script that utilizes Oracle’s DBMS_SCHEDULER to create and execute CPU-bound jobs. Additionally, it addresses constraints of the Oracle Database 23ai Free version, limiting CPU usage to two cores.

#Oracle
CPU-intensive query to simulate CPU load in Oracle database
This blog post provides a PL/SQL script that utilizes Oracle’s DBMS_SCHEDULER to create and execute CPU-bound jobs. Also validates the CPU usage with AWR Report and docker stats command. Addi…
dincosman.com
December 15, 2024 at 10:52 AM
osmandinc.bsky.social
The Debate Between Table Statistics and SELECT COUNT(*)
#Oracle

dincosman.com/2024/12/07/f...
How to Get Row Counts for All Tables in Oracle Database?
This post explores the debate between using table statistics and executing SELECT COUNT(*) queries for retrieving row counts for all tables in Oracle databases. It highlights the efficiency of rely…
dincosman.com
December 8, 2024 at 9:54 AM
osmandinc.bsky.social
Install Oracle Database 23ai and Sample Schemas on Macbook M Series (Apple Silicon)

#Oracle
dincosman.com/2024/12/03/i...
Install Oracle Database 23ai and Sample Schemas on Macbook M Series (Apple Silicon)
Released on 12th November 2024, Oracle Database 23ai now offers free container images optimized for ARM-based Apple MacBook computers with M-series chips, enhancing development efficiency. Two imag…
dincosman.com
December 3, 2024 at 5:00 PM
osmandinc.bsky.social
New blog Post - File System Corruption on Root (/) Partition of Exadata Storage Server - Oracle Linux 7
#Oracle #Exadata
dincosman.com/2024/12/01/e...
File System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7
A file system corruption issue was detected on the root partition of an Exadata storage server running Oracle Linux 7.9. This was identified by AIDE due to changes in file attributes. Investigation…
dincosman.com
December 1, 2024 at 7:21 AM
osmandinc.bsky.social
Upgrade the Database Time Zone (DST) Version: Key Considerations

The necessity of a time zone upgrade depends on whether a database stores timestamp data with time zones.

dincosman.com/2024/11/16/d...
#Oracle #Database #DST #TimeZone #DBTIMEZONE #Upgrade #Databases #TSTZ #SQL
Upgrade the Database Time Zone (DST) Version: Key Considerations
The necessity of a time zone upgrade depends on whether a database stores timestamp data with time zones. For organizations with clients in various time zones, upgrading may be essential. The data …
dincosman.com
November 17, 2024 at 1:06 PM
osmandinc.bsky.social
First post on BlueSky. This new place is really cool and feels so fresh.

Is it possible to audit a specific column for specific users only, and only when rows are returned? I demonstrate how to do this using DBMS_FGA.

#Oracle #Database #SQL #DatabaseSecurity

dincosman.com/2024/11/10/f...
Column-Level Auditing for Specific Users, Audited Only When Rows Are Returned
Unified Auditing mechanism currently in 19c lacks affected rows count reporting and column-level monitoring, presenting challenges in detecting data accesses. Upcoming Oracle Database 23ai will int…
dincosman.com
November 15, 2024 at 5:57 PM