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)
MISSING_PRIVILEGES (explained further below).
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices