eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.DBA_SUMMARIES

Object Details

Object Name:	DBA_SUMMARIES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of the summaries accessible to dba

[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.DBA_SUMMARIES;

Dependencies

[top of page]

SYS.DBA_SUMMARIES references the following:

SYS: OBJ$; SNAP$; SUM$; USER$

SYS.DBA_SUMMARIES is referenced by following:

PUBLIC: DBA_SUMMARIES
SYS: DBMS_SNAPSHOT - show dependent code