V$AQ_NONDUR_REGISTRATIONS

7.18 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