CBO 10053 trace

Resp in the CBO 10053 Trace File

2025-02-03

CBO 10053 trace, CBO costing, Parallel Query, Resc, Resp

Oracle Blog

Resp: you might have spotted it “here and there” in the 10053 trace file.It may turn out important if, for example, all of sudden your SQL similar to the one below starts running in parallel (of what you may not be aware straight away), visibly slower – and most of all wasting I/O and CPU…
Cartesian Join – the usual suspect (part2)

2025-01-13

Analysis of costing of joins in 10053, Cartesian Join, CBO 10053 trace, Hash Join, Nested Loop, Oracle SQL optimization, Performance Tuning, Sort Merge Join

Oracle Blog

Analysis of joins with 10053 CBO trace This post continues from Part 1, diving deeper into the challenges posed by a suboptimal SQL query that led the optimizer to select a Cartesian Join combined with an overly expensive Hash Join.But do not treat its content as limited to just a Cartesian Join.It will also help…