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

VIEW: SYS.CDB_ENABLED_AGGREGATIONS

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

Information about enabled on-demand statistic aggregation in all containers

[View Source]

Columns
Name Datatype Length Mandatory 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)
CON_ID NUMBER

container id
Query Text

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


SELECT AGGREGATION_TYPE
,      PRIMARY_ID
,      QUALIFIER_ID1
,      QUALIFIER_ID2
,      CON_ID
FROM SYS.CDB_ENABLED_AGGREGATIONS;

Dependencies

[top of page]

SYS.CDB_ENABLED_AGGREGATIONS does not reference any database object

SYS.CDB_ENABLED_AGGREGATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_ENABLED_AGGREGATIONS