4.45 ALL_SAGA_DETAILS

ALL_SAGA_DETAILS displays details for sagas accessible to the current user.

Related Views

  • DBA_SAGA_DETAILS displays details for all sagas in the database.

  • USER_SAGA_DETAILS displays details for sagas owned by the current user.

Column Datatype NULL Description

ID

RAW(16)

NOT NULL

Saga ID

PARTICIPANT

VARCHAR2(128)

NOT NULL

Name of the saga participant

SOURCE

VARCHAR2(128)

Name of the saga participant responsible for the event

TARGET

VARCHAR2(128)

Name of the saga participant that is the target for the event

MESSAGE

VARCHAR2(2048)

Short description of the event

TYPE

NUMBER

 

Type of event

QUEUE_TYPE

NUMBER

NOT NULL

Type of saga queue

CREATED_TIME

TIMESTAMP(6) WITH TIME ZONE

Time at which the event was processed

MESSAGE_ID

RAW(16)

 

Internal identifier of the message

CORRELATION

VARCHAR2(128)

 

Correlation identifier

Note:

This view is available starting with Oracle Database 23ai.