26.4.3.36 The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings Views

These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts.

The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns:

  • query

    The normalized statement string.

  • db

    The default database for the statement, or NULL if there is none.

  • exec_count

    The total number of times the statement has executed.

  • errors

    The total number of errors produced by occurrences of the statement.

  • error_pct

    The percentage of statement occurrences that produced errors.

  • warnings

    The total number of warnings produced by occurrences of the statement.

  • warning_pct

    The percentage of statement occurrences that produced warnings.

  • first_seen

    The time at which the statement was first seen.

  • last_seen

    The time at which the statement was most recently seen.

  • digest

    The statement digest.