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_ENABLED_AGGREGATIONS

Object Details

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

Information about enabled on-demand statistic aggregation

[View Source]

Columns

Name	Datatype	Length	Comments
AGGREGATION_TYPE	VARCHAR2	(21)	Type of the aggregation (CLIENT_ID, SERVICE, etc.)
PRIMARY_ID	VARCHAR2	(64)	Primary qualifier (specific Client Identifier or Service name)
QUALIFIER_ID1	VARCHAR2	(48)	Secondary qualifier (specific MODULE name)
QUALIFIER_ID2	VARCHAR2	(32)	Additional qualifier (specific ACTION name)

Query Text

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


SELECT AGGREGATION_TYPE
,      PRIMARY_ID
,      QUALIFIER_ID1
,      QUALIFIER_ID2
FROM SYS.DBA_ENABLED_AGGREGATIONS;

Dependencies

[top of page]

SYS.DBA_ENABLED_AGGREGATIONS references the following:

SYS: WRI$_AGGREGATION_ENABLED

SYS.DBA_ENABLED_AGGREGATIONS is referenced by following:

PUBLIC: DBA_ENABLED_AGGREGATIONS