Osman DINC - InsaneDBA
@osmandinc.bsky.social
📤 96
đź“Ą 414
đź“ť 31
I love and tame databases and share my knowledge on
https://dincosman.com/
Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool.
dincosman.com/2025/11/09/b...
#Oracle
#RMAN
#Database
#BackupAndRecovery
loading . . .
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’…
https://dincosman.com/2025/11/09/backupto-fake-tape-rman/
20 days ago
0
2
0
Ping Checks Life, tnsping Checks Purpose
#JoelKallmanDay
#Oracle
dincosman.com/2025/10/15/p...
loading . . .
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…
https://dincosman.com/2025/10/15/ping-tnsping-ociping-connping/
about 1 month ago
0
1
0
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
5 months ago
0
2
0
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
loading . . .
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…
https://dincosman.com/2025/06/18/deploy-autonomous-database-locally/
5 months ago
0
5
3
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...
loading . . .
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 …
https://dincosman.com/2025/06/14/autoupgrade-offline-patch/
6 months ago
0
0
0
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
loading . . .
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…
https://dincosman.com/2025/06/04/download-patches-behind-proxy/
6 months ago
0
1
0
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
loading . . .
6 months ago
0
2
0
Oracle 23ai Update – VKTM process is now TIME!
#Oracle
6 months ago
0
0
0
New Blog Post : Part 1: NVL vs DECODE and CASE - Short Circuit Behavior
dincosman.com/2025/05/17/n...
#Oracle
#Database
#SQL
#NVLvsDECODE
loading . . .
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…
https://dincosman.com/2025/05/17/nvl-eager-evaluates/
6 months ago
0
2
0
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
loading . . .
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…
https://dincosman.com/2025/05/09/oracle-hash-partitioning/
7 months ago
0
1
0
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
loading . . .
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…
https://dincosman.com/2025/05/02/get-ddl-user-password/
7 months ago
1
0
0
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
loading . . .
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…
https://dincosman.com/2025/04/26/ansible-for-oracle-dba/
7 months ago
0
0
0
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
loading . . .
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…
https://dincosman.com/2025/04/10/sqlplanbaselines-sqlpatches-sqlprofiles/
8 months ago
0
5
0
New blog post: Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect
dincosman.com/2025/03/13/c...
loading . . .
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…
https://dincosman.com/2025/03/13/cluster-interconnects/
9 months ago
0
1
0
New Blog Post: Tools for Oracle Database Proactive Health Checks and Diagnostics
dincosman.com/2025/02/23/o...
loading . . .
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…
https://dincosman.com/2025/02/23/oracle-database-health/
9 months ago
0
3
0
Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE
dincosman.com/2025/02/09/b...
loading . . .
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…
https://dincosman.com/2025/02/09/bind-var-related-child-cursors/
10 months ago
0
0
0
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...
loading . . .
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…
https://dincosman.com/2025/01/03/move-tablespace/
11 months ago
0
1
0
Oracle Database APEX Upgrade: 19.2 to 24.1
dincosman.com/2024/12/21/o...
loading . . .
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…
https://dincosman.com/2024/12/21/oracle-apex-upgrade/
11 months ago
0
0
0
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
loading . . .
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…
https://dincosman.com/2024/12/13/cpu-intensive-query-for-oracle/
12 months ago
0
5
0
The Debate Between Table Statistics and SELECT COUNT(*)
#Oracle
dincosman.com/2024/12/07/f...
loading . . .
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…
https://dincosman.com/2024/12/07/find-row-counts-oracle/
12 months ago
0
1
0
Install Oracle Database 23ai and Sample Schemas on Macbook M Series (Apple Silicon)
#Oracle
dincosman.com/2024/12/03/i...
loading . . .
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…
https://dincosman.com/2024/12/03/install-oracle23ai-on-macbook/
12 months ago
0
2
0
New blog Post - File System Corruption on Root (/) Partition of Exadata Storage Server - Oracle Linux 7
#Oracle
#Exadata
dincosman.com/2024/12/01/e...
loading . . .
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…
https://dincosman.com/2024/12/01/exadata-file-system-corruption/
12 months ago
0
1
0
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
loading . . .
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 …
https://dincosman.com/2024/11/16/database-time-zone-upgrade/
about 1 year ago
0
0
0
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...
loading . . .
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…
https://dincosman.com/2024/11/10/fga-audit-condition/
about 1 year ago
0
1
0
you reached the end!!
feeds!
log in
