deforigin.sql
---------------------------------------------------------------------------
-- Filename: deforigin.sql
-- Purpose: Lists data from system.def$_origin.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
column origin_db heading "Origin|DB" format a15
column origin_dblink heading "Origin|DB Link" format a15
column inusr heading "INUSR" format 99999
column cscn heading "CSCN" format 999999999
column eng_tid heading "Enqueue|Txn ID" format a15
column reco_seq_no heading "Reco|Seq|No" format 99999
SELECT origin_db,
origin_dblink,
inusr,
cscn,
enq_tid,
reco_seq_no
FROM system.def$_origin
/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.
