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

TABLE: SYS.AQ$_QUEUE_SHARDS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: AQ$_QUEUE_SHARD_PK
  1. ColumnQUEUE
  2. ColumnSHARD
Indexes
Index Type Uniqueness Tablespace Column
AQ$_QUEUE_SHARD_PK NORMAL UNIQUE TablespaceSYSTEM ColumnQUEUE
ColumnSHARD
Columns
Name Datatype Length Mandatory Comments
QUEUE NUMBER
Yes
SHARD NUMBER
Yes
ENQUEUE_INSTANCE NUMBER
Yes
PREFERRED_OWNER_INSTANCE NUMBER
Yes
OWNER_INSTANCE NUMBER
Yes
FLAGS NUMBER

Query Text

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


SELECT QUEUE
,      SHARD
,      ENQUEUE_INSTANCE
,      PREFERRED_OWNER_INSTANCE
,      OWNER_INSTANCE
,      FLAGS
FROM SYS.AQ$_QUEUE_SHARDS;

Dependencies

[top of page]

SYS.AQ$_QUEUE_SHARDS does not reference any database object

SYS.AQ$_QUEUE_SHARDS is referenced by following:

SchemaSYS
Package BodyDBMS_AQ_SYS_EXP_INTERNAL - show dependent code
Package BodyDBMS_AQ_SYS_IMP_INTERNAL - show dependent code