resconfs.sql

---------------------------------------------------------------------------
-- Filename:    resconfs.sql
-- Purpose:     Reports on all resolved conflicts.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        11-Jun-1998
--
-- Modification History
-- -------------------
-- 11-Jun-1998 : Chas. : Creation
---------------------------------------------------------------------------
col primary_key_value   form a10        heading "Primary|Key"
col oname               form a25        heading "Object Name"
col conflict_type       form a8         heading "Conflict|Type"
col method_name         form a18        heading "Resolution|Method"
col resolved_date       form a15        heading "Resolution|Date"

SELECT  oname,
        primary_key_value,
        conflict_type,
        method_name,
        to_char(resolved_date, 'DD-Mon HH24:MI:SS') resolved_date
FROM    dba_represolution_statistics
/

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial