The list of topic subscribers that are currently registered with a topic. Each row represents a single subscriber listening to a topic.

Column

Data Type

Constraint

client_id

NUMERIC(19)

NULL

The client ID of the client that created the subscriber.

subscriber_name

VARCHAR(250)

NULL

The unique name used by the client to identify the subscriber.

subscriber_id

NUMERIC(19)

NOT NULL

The subscriber ID of the subscriber receiving the message.

topic_id

NUMERIC(19)

NULL

The topic ID of the topic the subscriber is registered to listen to.

durable

NUMERIC(1)

NULL

Denotes whether or not the subscriber is durable. Durable subscribers have a value of 1. Non-durable subscribers have the value zero.

active

NUMERIC(1)

NULL

Denotes whether or not the subscriber is flagged as active by the client.


Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.

Legal Notices