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
oracle
2026
Reserved words in Oracle databases
In Oracle databases, many words are reserved for specific uses or entirely. This helps eliminate typos in SQL statements. You...
March 18, 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 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
Assertions Use Cases in Oracle
Assertions are boolean expressions that have the semantics of a constraint. The database must ensure the truth of these boolean...
March 12, 2026
2025
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
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
