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

VIEW: SYS.USER_SUMMARIES

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

Description of the summaries created by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the summary
SUMMARY_NAME VARCHAR2 (128) Yes Name of the summary
CONTAINER_OWNER VARCHAR2 (128) Yes Owner of the container table
CONTAINER_NAME VARCHAR2 (128)
Name of the container table for this summary
LAST_REFRESH_SCN NUMBER

The SCN of the last transaction to refresh the summary
LAST_REFRESH_DATE DATE

The date of the last refresh of the summary
REFRESH_METHOD VARCHAR2 (11)
User declared method of refresh for the summary
SUMMARY VARCHAR2 (1)
Indicates the presence of either aggregation or a GROUP BY
FULLREFRESHTIM NUMBER

The time that it took to fully refresh the summary
INCREFRESHTIM NUMBER

The time that it took to incrementally refresh the summary
CONTAINS_VIEWS VARCHAR2 (1)
This summary contains views in the FROM clause
UNUSABLE VARCHAR2 (1)
This summary is unusable, the build was deferred
RESTRICTED_SYNTAX VARCHAR2 (1)
This summary contains restrictive syntax
INC_REFRESHABLE VARCHAR2 (1)
This summary is not restricted from being incrementally refreshed
KNOWN_STALE VARCHAR2 (1)
This summary is directly stale
QUERY_LEN NUMBER

QUERY LONG (0)
Query Text

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


SELECT OWNER
,      SUMMARY_NAME
,      CONTAINER_OWNER
,      CONTAINER_NAME
,      LAST_REFRESH_SCN
,      LAST_REFRESH_DATE
,      REFRESH_METHOD
,      SUMMARY
,      FULLREFRESHTIM
,      INCREFRESHTIM
,      CONTAINS_VIEWS
,      UNUSABLE
,      RESTRICTED_SYNTAX
,      INC_REFRESHABLE
,      KNOWN_STALE
,      QUERY_LEN
,      QUERY
FROM SYS.USER_SUMMARIES;

Dependencies

[top of page]

SYS.USER_SUMMARIES references the following:

SchemaSYS
TableOBJ$
TableSNAP$
TableSUM$
TableUSER$
SYS.USER_SUMMARIES is referenced by following:

SchemaPUBLIC
SynonymUSER_SUMMARIES