How to find chained rows in a table ?
A chained row is a row that does not fit into a single database block. For example, if you try...
December 23, 2025
oracle
2025
Generating DDL script for a schema by using impdp
SQLFILE parameter in impdp can be used to generate the DDLs from a dumpfile. If you need the DDL of...
October 9, 2025
SQL Tuning Health-Check Script (SQLHC)
SQL Tuning Health-Check Script (SQLHC) is used to check the environment in which a single SQL statement is running, Cost-based...
March 19, 2025
2024
Execution plan fixing in Oracle databases
In some cases in Oracle databases, queries may run with bad plans due to optimizers not being able to make...
November 19, 2024
In which cases , indexes should be rebuild ?
In Oracle databases, indexes become fragmented over time and cause serious performance problems. Indexes must be checked regularly and, if...
November 19, 2024
Oracle Flashback Query
Oracle Flashback Query allows the use of select query with AS OF. It allows us to query as much of...
November 8, 2024
Goldengate “Not enough database memory” issue
If Goldengate extract services fail to start with errors such as the ones below, the solution is very easy. Possible...
November 8, 2024
Oracle 12c IDENTITY Columns & Default SEQUENCES
I will try to explain the identity field, which is my favorite innovation in Oracle 12c. MS SQL, MYSQL users...
November 8, 2024
Users which have Create any procedure and Execute any procedure privilege can assign themselves the DBA role.
In Oracle databases prior to 12c, users which have create any procedure and execute any procedure privileges could assign themselves the dba role. This...
October 8, 2024
What is Supplemental Logging?
Redo log files are often used for instance recovery and media recovery. The data required for such operations is automatically...
September 25, 2024
