Duplicating Pluggable Databases with sysbackup
Duplicate of pluggable databases doesn’t work with SYSBACKUP. The privilege rule seems to be hardcoded in an Oracle C function. Continue Reading
Duplicate of pluggable databases doesn’t work with SYSBACKUP. The privilege rule seems to be hardcoded in an Oracle C function. Continue Reading
The creation of new histograms invalidates synopses. Continue Reading
Top consumer information included in the incident file. Continue Reading
Wrong cardinality calculation for multi-column join with filter predicate and extended statistics Continue Reading
Inline hint can cause ORA-07445 in 18c and 19c. Continue Reading
A stuck nanosleep call impairs a parallel recovery process. The affected parallel recovery process spends 100% of its time in the undocumented parallel recovery push change wait event. Continue Reading
A process waiting on an Advanced Queue or alert allocates an in-memory undo buffer and holds it as long as it’s waiting, even when there aren’t any incoming mesages. Many such processes can prevent private strands usage.
Continue Reading
Troubleshooting wrong v$transaction.start_time entries. Undocumented internals on how Oracle populates x$ktcxb. Continue Reading
How to overcome the limitations of expansion of OR-subqueries in Oracle 19c. Continue Reading
Suboptimal handling of lateral views has improved in Oracle 19c. Continue Reading