Oracle Database - Trace File 10053 to understand the Optimizer (CBO)

Card Puncher Data Processing


The reason for examining a 10053 is typically to understand why the CBO made its decisions. The 10053 will help answer the question:

  • “Why was my index not used?” or the related,
  • “Why did the CBO choose an FTS?”.

The 10053 is typically not the best place to start looking for tuning opportunities:

have better information in this regard.

The 10053 is used for deeper cause determination.

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - Trace File (.trc)

Trace File are trace (or dump) file that Oracle Database creates to help you diagnose and resolve operating problems. Each server and background process writes to a trace file. When a process detects...

Share this page:
Follow us:
Task Runner