DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.AQ$_SUBSCRIBER_LWM

Object Details
Object Name: AQ$_SUBSCRIBER_LWM
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Unique Key: AQ$_SUBSCRIBER_LWM_UNIQUE
  1. ColumnQUEUE_ID
  2. ColumnSHARD_ID
  3. ColumnPRIORITY
  4. ColumnSUBSCRIBER_ID
Indexes
Index Type Uniqueness Tablespace Column
AQ$_SUBSCRIBER_LWM_UNIQUE NORMAL UNIQUE TablespaceSYSTEM ColumnQUEUE_ID
ColumnSHARD_ID
ColumnPRIORITY
ColumnSUBSCRIBER_ID
Columns
Name Datatype Length Mandatory Comments
QUEUE_ID NUMBER
Yes
SUBSCRIBER_ID NUMBER

SHARD_ID NUMBER
Yes
PRIORITY NUMBER

LWM NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUEUE_ID
,      SUBSCRIBER_ID
,      SHARD_ID
,      PRIORITY
,      LWM
FROM SYS.AQ$_SUBSCRIBER_LWM;

Dependencies

[top of page]

SYS.AQ$_SUBSCRIBER_LWM does not reference any database object

SYS.AQ$_SUBSCRIBER_LWM is not referenced by any database object