repcatlog.sql
--------------------------------------------------------------------------- -- Filename: repcatlog.sql -- Purpose: Lists all tasks pending in dba_repcatlog queue. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 28-Jun-1996 --------------------------------------------------------------------------- column SOURCE heading "Source" format a6 column MASTER heading "Master" format a6 column SNAME heading "Group" format a10 column STATUS heading "Status" format a14 column REQUEST heading "Request" format a28 column TIMESTAMP heading "Time" format a8 SELECT substr(source, 1, instr(source, '.', 1) -1 ) source, substr(master, 1, instr(master, '.', 1) -1 ) master, sname, status, request, to_char(timestamp, 'HH24:MI:SS') timestamp FROM dba_repcatlog ORDER BY master /
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.