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
oracle
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
