Osman DINC - InsaneDBA

Osman DINC - InsaneDBA

@osmandinc.bsky.social

Ankara, I love and tame databases and share my knowledge on https://dincosman.com/

104 followers419 following40 posts

Osman DINC - InsaneDBA
@osmandinc.bsky.social

Oracle Database Appliance Disk State FAILED / DiskRemoved but ASM Healthy: Troubleshooting Guide dincosman.com/2026/05/17/o... #Oracle #DBA #EngineeredSystems #Linux #ASM #DataStorage #Troubleshooting #OracleODA

dincosman.comOracle Database Appliance Disk State FAILED / DiskRemoved but ASM Healthy: Troubleshooting GuideWhile working with an Oracle Database Appliance, an inconsistency arose between the management layer and the storage stack, leading to a disk reported as “FAILED” by odaadmcli. Further …
Osman DINC - InsaneDBA
@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

dincosman.comDeploy Oracle Autonomous Database on your ComputerOracle 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…
Osman DINC - InsaneDBA
@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...

dincosman.comOracle Database Patching with AutoUpgrade in Offline EnvironmentsThis 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 …
Osman DINC - InsaneDBA
@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

dincosman.comDownloading Oracle Patches with AutoUpgrade on Windows Behind a ProxyIn 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…
Osman DINC - InsaneDBA
@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

dincosman.comOracle Hash Partitioning: Benefits and Best PracticesHash partitioning enhances database management and performance by evenly distributing data across partitions, crucial for handling high concurrency. However, choosing an appropriate partition key i…
Osman DINC - InsaneDBA
@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

dincosman.comDBMS_METADATA.GET_DDL Does Not Return Hashed Passwords AnymoreRecent 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…
Osman DINC - InsaneDBA
@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

dincosman.comAnsible 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…
Osman DINC - InsaneDBA
@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

dincosman.comSQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use CasesThis 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…
Osman DINC - InsaneDBA
@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...

dincosman.comMoving Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in DetailThe 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…
Osman DINC - InsaneDBA
@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

dincosman.comCPU-intensive query to simulate CPU load in Oracle databaseThis 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…
Osman DINC - InsaneDBA
@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...

dincosman.comFile System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7A 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…
Osman DINC - InsaneDBA
@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

dincosman.comUpgrade the Database Time Zone (DST) Version: Key ConsiderationsThe 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 …
Osman DINC - InsaneDBA
@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...

dincosman.comColumn-Level Auditing for Specific Users, Audited Only When Rows Are ReturnedUnified 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…

You are up to date.