Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_APPLY_ERROR

Error transactions that were generated after dequeuing from the queue visible to the current user 

Columns
   ___________________________
 
   APPLY_NAME
      Name of the apply process at the local site which processed the transaction
   QUEUE_NAME
      Name of the queue at the local site where the transaction came from
   QUEUE_OWNER
      Owner of the queue at the local site where the transaction came from
   LOCAL_TRANSACTION_ID
      Local transaction ID for the error creation transaction
   SOURCE_DATABASE
      Database where the transaction originated
   SOURCE_TRANSACTION_ID
      Original transaction ID at the source database
   SOURCE_COMMIT_SCN
      Original commit SCN for the transaction at the source database
   MESSAGE_NUMBER
      Identifier for the message in the transaction that raised an error
   ERROR_NUMBER
      Error number
   ERROR_MESSAGE
      Error message
   RECIPIENT_ID
      User ID of the original recipient
   RECIPIENT_NAME
      Name of the original recipient
   MESSAGE_COUNT
      Total number of messages inside the error transaction

Related:


Simon Sheppard
 SS64.com