The OPTIMIZER_TRACE
table contains
information about traced statements. The table has these columns:
QUERY
: The statement text.TRACE
: The trace, in JSON format (see json.org: basically it has scalars (number, string, bool) and structures (either arrays or associative arrays)).MISSING_BYTES_BEYOND_MAX_MEM_SIZE
: Explained further below.INSUFFICIENT_PRIVILEGES
: Explained further below.