V$AQ_NONDUR_REGISTRATIONS

V$AQ_NONDUR_REGISTRATIONS provides information about non-durable subscriptions.

Column Datatype Description
REG_ID NUMBER Registration ID
SUBSCRIPTION VARCHAR2(128) Subscription name
LOCATION VARCHAR2(256) Location name
USER# NUMBER User ID
USER_CONTEXT RAW(32) Context the user provided
CONTEXT_SIZE NUMBER Size of the context
NAMESPACE NUMBER Subscription namespace
VERSION NUMBER Database version number
STATE NUMBER

State of the registration:

  • ENABLED: The registration is enabled for notification

  • STOPPING: The registration is in a transient state before it becomes DISABLED

  • DISABLED: The registration is disabled for notification

  • DEAD: The registration does not exist any more, and it is marked for deferred cleanup.

QOS NUMBER Quality of service
REG_TIME TIMESTAMP(3) WITH TIME ZONE Time of registration
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also: Oracle AI Database Transactional Event Queues and Advanced Queuing User’s Guide for more information about Oracle Database Advanced Queueing