Osman DİNÇ – Medium

Osman DİNÇ

Osman DİNÇ
in
DevOps.dev

Resolving Enq: TX — Row Lock Contention with Real-life Scenario Analysis

Detecting Uncommitted SQL Causing Enq: Tx — Row Lock Contention.

Sep 1

Resolving Enq: TX — Row Lock Contention with Real-life Scenario Analysis

Sep 1

Osman DİNÇ
in
DevOps.dev

Reducing Hard Parses: Understanding SQL Cursor Invalidation

Choosing the Right Option for Materialized View Refresh to Reduce Hard Parses

Aug 25

Reducing Hard Parses: Understanding SQL Cursor Invalidation

Aug 25

Osman DİNÇ
in
DevOps.dev

How to configure HAProxy with external check to query PostgreSQL database directly

Querying the database replication state directly from PgBouncer connection pool in HAProxy

Aug 10

How to configure HAProxy with external check to query PostgreSQL database directly

Aug 10

Osman DİNÇ

Oracle 23ai Fuzzy Matching and Similarity Searches

Search like Google in Oracle

Aug 4

Oracle 23ai Fuzzy Matching and Similarity Searches

Aug 4

Osman DİNÇ
in
DevOps.dev

Sharing Oracle Audit Records with SIEM Tools Using JSON Functions

Sql Statement is not recorded in syslog of Unified Audit Trail

Aug 4

Sharing Oracle Audit Records with SIEM Tools Using JSON Functions

Aug 4

Osman DİNÇ
in
DevOps.dev

Understanding pg_trgm in PostgreSQL: A Quick Overview

PostgreSQL, known for its powerful and flexible full-text search capabilities (to_tsvector, to_tsquery etc), includes the pg_trgm extension…

Aug 2

Understanding pg_trgm in PostgreSQL: A Quick Overview

Aug 2

Osman DİNÇ
in
DevOps.dev

How to Remove Orphan Large Objects in PostgreSQL

Binary Large Objects (BLOBS) in PostgreSQL should be removed using the lo_unlink() function.

Jul 27

How to Remove Orphan Large Objects in PostgreSQL

Jul 27

Osman DİNÇ
in
DevOps.dev

Compare Oracle Database Hashed Passwords with Plaintext String

Testing Top 1 Million Weak Passwords with SYSTEM user account

Jul 26

Compare Oracle Database Hashed Passwords with Plaintext String

Jul 26

Osman DİNÇ
in
DevOps.dev

Unusable and Parallel indexes on Flashback Data Archive Tables in 19.22

Update Indexes Clause is missing in split operation of FDA Internal Tables

Jun 24

Unusable and Parallel indexes on Flashback Data Archive Tables in 19.22

Jun 24

Osman DİNÇ
in
DevOps.dev

Holistic Patching for Oracle Enterprise Manager

Simple and Secure: Holistic Patching for Enterprise Manager

Jun 11

Holistic Patching for Oracle Enterprise Manager

Jun 11

Osman DİNÇ

Osman DİNÇ

I love and tame databases and share my knowledge on https://dincosman.com. Deep knowledge and experience in Oracle and Postgresql dbs in all aspects

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams