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

VIEW: SYS._DBA_QUEUE_STATS1

Object Details
Object Name: _DBA_QUEUE_STATS1
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUEUE_NAME VARCHAR2 (128) Yes
EVENTID NUMBER
Yes
USAGE NUMBER
Yes
SCHEMA VARCHAR2 (128) Yes
TABLE_NAME VARCHAR2 (128) Yes
FLAGS NUMBER
Yes
TIMEZONE VARCHAR2 (64)
Query Text

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


SELECT QUEUE_NAME
,      EVENTID
,      USAGE
,      SCHEMA
,      TABLE_NAME
,      FLAGS
,      TIMEZONE
FROM SYS._DBA_QUEUE_STATS1;

Dependencies

[top of page]

SYS._DBA_QUEUE_STATS1 references the following:

SchemaSYSTEM
TableAQ$_QUEUES
TableAQ$_QUEUE_TABLES

SYS._DBA_QUEUE_STATS1 is not referenced by any database object