DBA Data[Home] [Help]

VIEW: SYS.DBA_ENABLED_AGGREGATIONS

Source

View Text - Preformatted

select decode(trace_type, 1, 'CLIENT_ID', 3, 'SERVICE',
                 4, 'SERVICE_MODULE', 5, 'SERVICE_MODULE_ACTION', 'UNDEFINED'),
                 primary_id, qualifier_id1, qualifier_id2
  from WRI$_AGGREGATION_ENABLED
View Text - HTML Formatted

SELECT DECODE(TRACE_TYPE
, 1
, 'CLIENT_ID'
, 3
, 'SERVICE'
, 4
, 'SERVICE_MODULE'
, 5
, 'SERVICE_MODULE_ACTION'
, 'UNDEFINED')
, PRIMARY_ID
, QUALIFIER_ID1
, QUALIFIER_ID2
FROM WRI$_AGGREGATION_ENABLED