DBA Data[Home] [Help]

VIEW: SYS.DBA_REPRESOLUTION_STATISTICS

Source

View Text - Preformatted

select
    sname,
    oname,
    decode(conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    reference_name,
    method_name,
    decode(method_name,
           'USER FUNCTION', function_name,
           'USER FLAVOR FUNCTION', function_name,
           NULL),
    priority_group,
    resolved_date,
    primary_key_value
from  system.repcat$_resolution_statistics
View Text - HTML Formatted

SELECT SNAME
, ONAME
, DECODE(CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, REFERENCE_NAME
, METHOD_NAME
, DECODE(METHOD_NAME
, 'USER FUNCTION'
, FUNCTION_NAME
, 'USER FLAVOR FUNCTION'
, FUNCTION_NAME
, NULL)
, PRIORITY_GROUP
, RESOLVED_DATE
, PRIMARY_KEY_VALUE FROM SYSTEM.REPCAT$_RESOLUTION_STATISTICS