There are two ways of creating multi-tenant container databases (CDB): Database Configuration Assistant and scripts. With the latter you have to run the script catcdb.sql for building data dictionary. This script calls a cascade of other Perl and sqlplus scripts,… Continue Reading
How to use gdb for capturing call stacks when trace lines are written Continue Reading
The index WRH$_SYSMETRIC_HISTORY_INDEX became UNUSABLE a couple of days after the Oracle 18c upgrade Continue Reading
Wrong cost calculation with recursive WITH subquery and OJPPD Continue Reading
Analyzing slow commits with ash_wait_chains.sql, gdb and DTrace Continue Reading
Reporting optimizer mistakes where the cost of operations in the execution plan wasn’t propagated to their parents Continue Reading
Suboptimal execution plans after falling back to OJPPD with hierarchical subqueries Continue Reading
Tracking function arguments with gdb, with an example of tracing memory allocations in Oracle database Continue Reading
Interpreting formulae; comparison to full table scan calculation Continue Reading
IO Sort Cost Calculation: formulae and internals Continue Reading