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

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 Database Advanced Queuing User's Guide for more information about Oracle Database Advanced Queueing