EXA_DBA_TRANSACTION​_CONFLICTS

This system table contains all transaction conflicts. This system table can be cleared by the statement TRUNCATE AUDIT LOGS. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
SESSION_ID ID of the session
CONFLICT_SESSION_ID Session which produces the conflict
START_TIME Start time of the conflict
STOP_TIME End time of the conflict or NULL if the conflict is still open
CONFLICT_TYPE Type of the conflict:
  • WAIT FOR COMMIT: One session has to wait until the other one is committed
  • TRANSACTION ROLLBACK: One session has to be rolled back due to a conflict
CONFLICT_OBJECTS Name of the corresponding objects
CONFLICT_INFO Additional information about the conflict