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

VIEW: SYS.CDB_SUMMARIES

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

Description of the summaries accessible to dba in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the summary
SUMMARY_NAME VARCHAR2 (30) Yes Name of the summary
CONTAINER_OWNER VARCHAR2 (30) 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

CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_SUMMARIES;

Dependencies

[top of page]

SYS.CDB_SUMMARIES does not reference any database object

SYS.CDB_SUMMARIES is referenced by following:

SchemaPUBLIC
SynonymCDB_SUMMARIES