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:
-
queryThe normalized statement string.
-
dbThe default database for the statement, or
NULLif there is none. -
exec_countThe total number of times the statement has executed.
-
errorsThe total number of errors produced by occurrences of the statement.
-
error_pctThe percentage of statement occurrences that produced errors.
-
warningsThe total number of warnings produced by occurrences of the statement.
-
warning_pctThe percentage of statement occurrences that produced warnings.
-
first_seenThe time at which the statement was first seen.
-
last_seenThe time at which the statement was most recently seen.
-
digestThe statement digest.
© 2025 Oracle
Licensed under the GPLv2 License.