Oracle AI Database 26ai: A Comprehensive Guide to FUZZY_MATCH and Text Matching
1. Introduction One of the most common challenges in database management is identifying duplicate or similar records when the same...
November 1, 2026
ORACLE
2026
Oracle AI Database 26ai : 50 Key Features Every DBA Should Know
Oracle AI Database 26ai represents an important evolution in Oracle’s database technology. It introduces significant enhancements across artificial intelligence,...
October 31, 2026
Oracle FAST_START_PARALLEL_ROLLBACK: Understanding and Tuning Parallel Rollback
In Oracle Database, the FAST_START_PARALLEL_ROLLBACK initialization parameter controls the degree of parallelism used during transaction rollback. It helps Oracle accelerate...
October 19, 2026
Mastering the KEEP Buffer Pool with Oracle True Cache
Oracle True Cache allows you to maximize memory efficiency by assigning specific database objects to the KEEP buffer pool across...
October 14, 2026
Priority Transactions in Oracle Database 26ai
The Oracle database supports automatic rollback of transactions and provides parameters to control this behavior. A row lock restricts access...
April 2, 2026
Automatic Degree of Parallelism and In-Memory Parallel Execution in Oracle Database
Parallel execution in Oracle Database enables the decomposition of a SQL statement into multiple smaller tasks, each executed concurrently by...
March 26, 2026
The causes and fix recommendations for frequently observed wait events in Oracle databases
Wait Event Cause / Problem Solution / Recommendation db file scattered read The session is waiting for a multiblock I/O...
March 26, 2026
Automatic Transaction Quarantine
Automatic Transaction Quarantine is a mechanism introduced in Oracle Database 26ai to enhance database availability by isolating transactions that fail...
March 26, 2026
Index quality in Oracle databases
Index quality is a factor that directly affects the overall database performance. The quality of an index is measured by...
March 18, 2026
How to find which objects are causing enq: HW – contention wait event ?
Enqueues are shared memory structures (locks) that serialize access to database resources. They can be associated with a session or...
March 18, 2026
How to convert LOB data stored as basicfile to securefile ?
SecureFiles LOB storage is one of two storage types used with Oracle databases; the other is BasicFiles LOB storage. Several...
March 18, 2026
How to find when a table was last modified
For each row in a table, ORA_ROWSCN returns the SCN information of the last change made to that row. This...
March 13, 2026
Enabling debugging in RMAN
Debugging/monitoring can be performed to obtain more detailed information about RMAN processes. This allows us to gain more insight than...
March 13, 2026
ORA-12988: cannot drop column from table owned by SYS
When attempting to delete a column from a table owned by a SYS user, the error “ORA-12988: cannot drop column...
March 13, 2026
Read Only Table Partitions
Read-Only Partitions Starting with Oracle version 12.2, partitions or sub-partitions of a table can be marked as read-only. This can...
March 13, 2026
